Question 1

The field type that holds alphanumeric or character data includes characters or numbers that ____.

Accepted Answer

A)  can be manipulated or used in calculations 
B)  cannot be manipulated or used in calculations 
C)  both a. and b. 
D)  neither a. nor b. 
A)  can be manipulated or used in calculations 
B)  cannot be manipulated or used in calculations 
C)  both a. and b. 
D)  neither a. nor b.

Question 2

The process of correcting data problems or anomalies is called ____.

Accepted Answer

A)  normalization 
B)  equalization 
C)  transition 
D)  calculation 
A)  normalization 
B)  equalization 
C)  transition 
D)  calculation

Question 3

-Referring to the figure above, an example of a primary key would be ____.

Accepted Answer

A)  005-10-6321 
B)  Hassam 
C)  257 
D)  10-7-2003 
A)  005-10-6321 
B)  Hassam 
C)  257 
D)  10-7-2003

Question 4

Some organizations use a ____ area network to connect multiple storage devices on high-speed networks to make recovering from a database failure faster and more efficient.

Accepted Answer

A)  storage 
B)  warehouse 
C)  database 
D)  mining 
A)  storage 
B)  warehouse 
C)  database 
D)  mining

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-A typically large database that holds important information from a variety of sources

Accepted Answer

A)  file b. distributed database 
C)  relational model 
D)  data integrity 
E)  data dictionary
F) data mining
G) data warehouse
H) data hierarchy
I) data center
J) schema
K) data analysis
L) record 
A)  file b. distributed database 
C)  relational model 
D)  data integrity 
E)  data dictionary
F) data mining
G) data warehouse
H) data hierarchy
I) data center
J) schema
K) data analysis
L) record

Question 6

The data ____________________ refers to the manner in which data in a database is organized into sequential levels of detail.

Accepted Answer

The answer of The data ____________________ refers to the manner...

Question 7

Databases use entities, attributes, and ____________________ to store data and information.

Accepted Answer

The answer of Databases use entities, attributes, and ____________________ to...

Question 8

When inaccurate data is entered into a database, the results are inaccurate output. This is sometimes referred to as garbage in, garbage out. _________________________

Accepted Answer

A) True 
 B)False

Question 9

A database backup is a copy of ____.

Accepted Answer

A)  all of the database 
B)  a part of the database 
C)  either a. or b. 
D)  neither a. nor b. 
A)  all of the database 
B)  a part of the database 
C)  either a. or b. 
D)  neither a. nor b.

Question 10

Examples of ____ include music CDs, the contents of an apartment, employees, inventory, and customers.

Accepted Answer

A)  keys 
B)  entities 
C)  properties 
D)  attributes 
A)  keys 
B)  entities 
C)  properties 
D)  attributes

Question 11

Sara Lewis is a teacher at Lakeside Junior College. When she came to class late, for the second time in a row, her students suggest she get a PIM. Sara is not sure "what a PIM is" and is doing some research.
-Sara discovers that a PIM can be used on her ____.

Accepted Answer

A)  personal computer 
B)  smart phone 
C)  either a. or b. 
D)  neither a. nor b. 
A)  personal computer 
B)  smart phone 
C)  either a. or b. 
D)  neither a. nor b.

Question 12

____ files are temporary files that hold data that needs to be processed.

Accepted Answer

A)  Programmed 
B)  Unprogrammed 
C)  Master 
D)  Transaction 
A)  Programmed 
B)  Unprogrammed 
C)  Master 
D)  Transaction

Question 13

The first data warehouses were developed at PacTel Cellular, Aetna Casualty, and Blue Cross/Blue Shield in the ____.

Accepted Answer

A)  1960s 
B)  1970s 
C)  1980s 
D)  1990s 
A)  1960s 
B)  1970s 
C)  1980s 
D)  1990s

Question 14

An important step in creating a database is to establish a data file, a detailed description of all data used in the database. _________________________

Accepted Answer

A) True 
 B)False

Question 15

Identify the letter of the choice that best matches the phrase or definition.
-A detailed description of all data used in the database

Accepted Answer

A)  file b. distributed database 
C)  relational model 
D)  data integrity 
E)  data dictionary
F) data mining
G) data warehouse
H) data hierarchy
I) data center
J) schema
K) data analysis
L) record 
A)  file b. distributed database 
C)  relational model 
D)  data integrity 
E)  data dictionary
F) data mining
G) data warehouse
H) data hierarchy
I) data center
J) schema
K) data analysis
L) record

Question 16

To users, distributed databases appear to be several small databases.

Accepted Answer

A) True 
 B)False

Question 17

Division usually involves breaking one table into two or more tables in order to correct a data problem or anomaly. _________________________

Accepted Answer

A) True 
 B)False

Question 18

All of the following are benefits of a centralized database approach EXCEPT: ____.

Accepted Answer

A)  Better access to data and information 
B)  Individualized methods of data access 
C)  Better overall protection of the data 
D)  Shared data and information resources 
A)  Better access to data and information 
B)  Individualized methods of data access 
C)  Better overall protection of the data 
D)  Shared data and information resources

Question 19

With a ____ database, also called a virtualized database, the actual data may be spread across several databases at different locations.

Accepted Answer

A)  distributed 
B)  joined 
C)  global 
D)  shared 
A)  distributed 
B)  joined 
C)  global 
D)  shared

Question 20

Shauna is the Database Administrator for an online store that sells cosmetics. They grew so fast that they ended up with seven different databases, and Shauna is now investigating how to set up a centralized database approach.
-Shauna also discovers that because there are no separate files that contain copies of the same piece of data, it no longer happens that changes sometimes are not reflected in all copies. This is called data ____.

Accepted Answer

A)  integrity 
B)  optimization 
C)  normalization 
D)  standardization 
A)  integrity 
B)  optimization 
C)  normalization 
D)  standardization

The field type that holds alphanumeric or character data includes characters or numbers that ____.

The process of correcting data problems or anomalies is called ____.

-Referring to the figure above, an example of a primary key would be ____.

Some organizations use a ____ area network to connect multiple storage devices on high-speed networks to make recovering from a database failure faster and more efficient.

Identify the letter of the choice that best matches the phrase or definition. -A typically large database that holds important information from a variety of sources

The data ____________________ refers to the manner in which data in a database is organized into sequential levels of detail.

Databases use entities, attributes, and ____________________ to store data and information.

When inaccurate data is entered into a database, the results are inaccurate output. This is sometimes referred to as garbage in, garbage out. _________________________

A database backup is a copy of ____.

Examples of ____ include music CDs, the contents of an apartment, employees, inventory, and customers.

Sara Lewis is a teacher at Lakeside Junior College. When she came to class late, for the second time in a row, her students suggest she get a PIM. Sara is not sure "what a PIM is" and is doing some research. -Sara discovers that a PIM can be used on her ____.

____ files are temporary files that hold data that needs to be processed.

The first data warehouses were developed at PacTel Cellular, Aetna Casualty, and Blue Cross/Blue Shield in the ____.

An important step in creating a database is to establish a data file, a detailed description of all data used in the database. _________________________

Identify the letter of the choice that best matches the phrase or definition. -A detailed description of all data used in the database

To users, distributed databases appear to be several small databases.

Division usually involves breaking one table into two or more tables in order to correct a data problem or anomaly. _________________________

All of the following are benefits of a centralized database approach EXCEPT: ____.

With a ____ database, also called a virtualized database, the actual data may be spread across several databases at different locations.

Why Study Computers and Digital Technologies

Hardware Designed to Meet the Need

Software Solutions for Personal and Professional Gain

The Internet and World Wide Web

Telecommunications, Wireless Technologies, and Computer Networks

Digital Media for Work and Leisure

E-Commerce

Information, Decision Support, and Special-Purpose Systems

Systems Development

Computer Crime and Information Security

Digital Society, Ethics, and Globalization

Filters

Exam 7: Database Systems

The field type that holds alphanumeric or character data includes characters or numbers that ____.

The process of correcting data problems or anomalies is called ____.

-Referring to the figure above, an example of a primary key would be ____.

Some organizations use a ____ area network to connect multiple storage devices on high-speed networks to make recovering from a database failure faster and more efficient.

Identify the letter of the choice that best matches the phrase or definition. -A typically large database that holds important information from a variety of sources

The data ____________________ refers to the manner in which data in a database is organized into sequential levels of detail.

Databases use entities, attributes, and ____________________ to store data and information.

When inaccurate data is entered into a database, the results are inaccurate output. This is sometimes referred to as garbage in, garbage out. _________________________

A database backup is a copy of ____.

Examples of ____ include music CDs, the contents of an apartment, employees, inventory, and customers.

Sara Lewis is a teacher at Lakeside Junior College. When she came to class late, for the second time in a row, her students suggest she get a PIM. Sara is not sure "what a PIM is" and is doing some research. -Sara discovers that a PIM can be used on her ____.

____ files are temporary files that hold data that needs to be processed.

The first data warehouses were developed at PacTel Cellular, Aetna Casualty, and Blue Cross/Blue Shield in the ____.

An important step in creating a database is to establish a data file, a detailed description of all data used in the database. _________________________

Identify the letter of the choice that best matches the phrase or definition. -A detailed description of all data used in the database

To users, distributed databases appear to be several small databases.

Division usually involves breaking one table into two or more tables in order to correct a data problem or anomaly. _________________________

All of the following are benefits of a centralized database approach EXCEPT: ____.

With a ____ database, also called a virtualized database, the actual data may be spread across several databases at different locations.

Why Study Computers and Digital Technologies

Hardware Designed to Meet the Need

Software Solutions for Personal and Professional Gain

The Internet and World Wide Web

Telecommunications, Wireless Technologies, and Computer Networks

Digital Media for Work and Leisure

E-Commerce

Information, Decision Support, and Special-Purpose Systems

Systems Development

Computer Crime and Information Security

Digital Society, Ethics, and Globalization

Filters