Test 2 COB 204 Flashcards

Chapter 4, 5, and 6. SQL Database.

1
Q

Which of the following are difficulties with managing data?
a) Rapid increase in the amount of data.
b) Data is often scattered across organizations.
c) Multiple and new sources of data.
d) lack of database software to handle data

A

A, B, and C

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

Database

A

Organized collection of data.

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

Which of the following are considered characteristics of ‘good’ data? (requires multiple answers)

A

Accurate, timely, and useful.

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

In a relational database, each table contains information about

A

An entity.

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

A database management system can help to reduce: (requires multiple answers)

A

Data redundancy, data isolation, data inconsistency.

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

The three architectural layers of software are

A

Bios/device drivers, operating systems, and application programs.

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

Why do computers use the binary or base2 number system?

A

2 states can be easily represented electronically.

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

What table is used to match binary integers with characters from the world’s languages?

A

Unicode table.

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

What statements are true regarding multimedia digital files?
a) Files are created by sampling actual sound and video.
b) A bigger sampling of actual sound and video results in a better-quality file.
c) Precisely measuring sample points from actual sound and video sampling results in a better-quality file.
d) They contain discreet data.

A

A, B, and C.

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

What are the two main components of an operating system?
a) Kernel
b) Shell
c) Bios/device drivers
d) application

A

A and B

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

Computer software such as operating systems and applications are stored when the computer is turned off in

A

Storage/hard drive.

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

A virtual computer/machine is

A

software emulation of computer hardware

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

Which of the following is the operating system used in a data center to control many physical computers and virtual machines?

A

Hypervisor

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

What category of application software is used across different industries?

A

Horizontal

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

What category of software is used within a specific industry?

A

Vertical

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

The definition of a computer network is

A

two or more computers that are connected and can exchange data

17
Q

Which of the following are disadvantages to cloud computing?
a) Dependency upon cloud vendor
b) Loss of Data Ownership
c) No Control over security
d) Must have Internet Access

A

A, B, C, and D

18
Q

What are the characteristics of packet-switched networks like the Internet? (requires multiple answers)
a) multi-path structure from one host to another
b) can continue to operate if portions are lost
c) packets will find the most efficient path from one host to another
d) the logic is circuit-switched

A

A, B, and C

19
Q

Which of the following are network applications? (requires multiple answers)
a) Web browser
b) Web server
c) Mobile Apps
d) Device drivers

A

A, B, and C

20
Q

TCP/IP, DNS, and Ethernet are all network

A

Protocols

21
Q

The difference between a LAN and a WAN is primarily

A

Involvement of a telecom provider

22
Q

The cloud service that provides just computer is

A

LAAS

23
Q

The cloud service that provides computer with operating systems is

A

PAAS

24
Q

The cloud service that provides computers with operating systems and applications is

A

SAAS

25
Q

Which of the following are advantages to cloud computing?
a) Scalability
b) No capital outlays for IT infrastructure
c) Expertise of Cloud Vendor
d) Mobile computing support

A

A, B, C, D.