Deck 64: Database Structure

Question 1

Microsoft Outlook and Quicken are examples of ____ DBMSs that are used to store and manipulate personal data.

A) special-purpose
B) flat
C) multi-user
D) single-user

Answer 1

A

Question 2

Data ____ refers to the quality and accuracy of the data.

A) warehousing
B) redundancy
C) modification
D) integrity

Answer 2

D

Question 3

Increased data redundancy is one of the primary advantages of using a database.

Answer 3

False

Question 4

A primary key is always made up of only one field.

Question 5

A common type of flat file database format known as ____ stores records as a line of text separated by commas.

A) CSV
B) relational
C) XLS
D) XML

Question 6

Online services such as Google and Amazon rely on data organized by databases.

Question 7

In a database,a collection of related records is referred to as a table or a ____.

A) field
B) record
C) file
D) unit

Question 8

In a database,first name would be an example of a ____.

A) field
B) record
C) file
D) unit

Question 9

The most popular format for flat file databases is comma-separated values (CSV).

Question 10

The iTunes library is based on database technology.

Question 11

Database structure refers to the manner in which data is organized and stored.

Question 12

To avoid data ____,a database stores data in one place.

A) redundancy
B) verification
C) integrity
D) validation

Question 13

A ____ is a collection of data that has been organized and made available to a user.

A) file
B) database
C) relationship
D) snippet

Question 14

A terabyte is equal to 1 billion bytes.

Question 15

The ability to connect data in different tables through a common field is sometimes referred to as a relationship.

Question 16

Big data is a term used to refer to data sets that are too large to process through traditional means.

Question 17

In a database,a collection of related fields that describes some object or activity is referred to as a ____.

A) field
B) record
C) file
D) unit

Question 18

Data integrity refers to the quality and accuracy of the data.

Question 19

A ____ is a program that lets computer users create and access a collection of organized data.

A) data definition language
B) data manipulation language
C) database management system
D) query by example

Question 20

A primary key is a ____ within a database table that uniquely identifies each record.

A) field
B) record
C) file
D) unit

Question 21

Primary keys ensure that ____.

A) all of the data is 100 percent accurate
B) duplicate records are not stored in the database
C) the data can be normalized
D) records are not accidentally deleted

Question 22

In a relational database,a ____ would ensure that two customers with the same name don't get confused with each other.

A) flat file
B) query
C) primary key
D) relationship

Question 23

____ involves combining two or more tables.

A) Joining
B) Relating
C) Querying
D) Normalizing

Question 24

____ is a concern for some organizations and individuals when data is collected in databases without their permission.

A) Data redundancy
B) Data collection
C) Privacy
D) Integrity

Question 25

Relationships between tables can be illustrated through a(n)____ relationship diagram.

A) field
B) file
C) record
D) entity

Question 26

A(n)____ database organizes data into multiple tables that are related by common fields.

A) hierarchical
B) object-oriented
C) flat file
D) relational