Test 2 COB 204 Flashcards
Chapter 4, 5, and 6. SQL Database.
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, B, and C
Database
Organized collection of data.
Which of the following are considered characteristics of ‘good’ data? (requires multiple answers)
Accurate, timely, and useful.
In a relational database, each table contains information about
An entity.
A database management system can help to reduce: (requires multiple answers)
Data redundancy, data isolation, data inconsistency.
The three architectural layers of software are
Bios/device drivers, operating systems, and application programs.
Why do computers use the binary or base2 number system?
2 states can be easily represented electronically.
What table is used to match binary integers with characters from the world’s languages?
Unicode table.
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, B, and C.
What are the two main components of an operating system?
a) Kernel
b) Shell
c) Bios/device drivers
d) application
A and B
Computer software such as operating systems and applications are stored when the computer is turned off in
Storage/hard drive.
A virtual computer/machine is
software emulation of computer hardware
Which of the following is the operating system used in a data center to control many physical computers and virtual machines?
Hypervisor
What category of application software is used across different industries?
Horizontal
What category of software is used within a specific industry?
Vertical
The definition of a computer network is
two or more computers that are connected and can exchange data
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, B, C, and D
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, B, and C
Which of the following are network applications? (requires multiple answers)
a) Web browser
b) Web server
c) Mobile Apps
d) Device drivers
A, B, and C
TCP/IP, DNS, and Ethernet are all network
Protocols
The difference between a LAN and a WAN is primarily
Involvement of a telecom provider
The cloud service that provides just computer is
LAAS
The cloud service that provides computer with operating systems is
PAAS
The cloud service that provides computers with operating systems and applications is
SAAS
