Computer Concepts Final Exam lecture 7 Flashcards

1
Q

What is bandwidth?

A

Speed or data transfer rate of network measured in kilobits per second.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is broadband?

A

Anything transferred over 10 mbps. Include DSL, cable internet access, satellite internet access, fiber-to-the home, mobile internet access and wifi hotspots.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

HTML meaning and purpose

A

Hypertext markup language that defines structure of a webpage.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

CSS meaning

A

Cascading style sheets - Computer language for laying out and structuring websites, seperates content of a website from its visual.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

URL meaning

A

Uniform resource locator. identifies website adresses on internet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is a domain name?

A

company, product or person associated with webpage.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are TLD and what does it mean.

A

The type of website we are visiting. .com, .edu, .gov.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What does the DNS (domain name system) do?

A

converts IP addresses into more friendly names such as google.com

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

T/F Synchronous online communication is real time communication between two or more people online at the same time?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

VoIP meaning

A

Voice over internet protocol. Internet calls instead of telephone lines or cell towers.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

T/F Asynchronous online communication allows for one to communicate without needing the other online?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is CAPTCHA?

A

Completely automated public turing test to tell computers and humans apart. Like the little check mark box or finding the bike in an image.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What does RSS stand for?

A

Really simple syndication. Basically allows websites and apps to redistribute updates and information in a standardized format. Like podcast list from most recent and with descriptions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

T/F Relational models take data and format it into a less structured format.

A

False. It is an intuitive, straightforward way of representing data in tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

4 components of ACID properties and what it helps with.

A

Atomic - transaction is completed entirely or not at all.
Consistent - must conform to existing data base rules.
Isolated - must not affect other transactions.
Durable - must get written to persistent storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

SQL meaning and purpose

A

Structured Query Language (SQL). Specialized programming language for managing data stored in relational databases.

17
Q

What is a database?

A

collection of information organized for easy access.

18
Q

Database cursor

A

mechanisms that enables traversal over records in a database.