Question 1

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

Accepted Answer

A) True 
 B)False

Question 2

Big data refers to large amounts of unstructured data from sources such as the Internet, photos, videos, audio, social networks, and sensors that is difficult to capture, store, and manipulate using traditional database management systems.

Accepted Answer

A) True 
 B)False

Question 3

When organizing a database, key considerations include determining what data to collect, who will have access to it, how they might want to use it, and how to monitor database performance.

Accepted Answer

A) True 
 B)False

Question 4

The smallest piece of data used by a computer is the _____.

Accepted Answer

A)  entity 
B)  byte 
C)  bit 
D)  character

Question 5

Selecting involves combining two or more tables.

Accepted Answer

A) True 
 B)False

Question 6

Online Analytical Processing and data mining are essentially the same thing.

Accepted Answer

A) True 
 B)False

Question 7

A data warehouse stores historical data that has been extracted from operational systems, external sources, and, sometimes, even unique sources.

Accepted Answer

A) True 
 B)False

Question 8

When creating backup databases, some companies use software to eliminate any duplicated data to save storage capacity and reduce costs, an approach some call data ______ .

Accepted Answer

The answer of When creating backup databases, some companies use...

Question 9

The allowable values for an attribute is called its _____.

Accepted Answer

The answer of The allowable values for an attribute is...

Question 10

______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Accepted Answer

A)  user view 
B)  schema 
C)  data definition language 
D)  data manipulation language

Question 11

A database, a database management system, and the application programs that use the data make up a database environment.

Accepted Answer

A) True 
 B)False

Question 12

Counterintelligence turns data into useful information that then is kept closely guarded to avoid this information from falling into the hands of the wrong employees.

Accepted Answer

A) True 
 B)False

Question 13

A collection of fields about a specific object is a record.

Accepted Answer

A) True 
 B)False

Question 14

Data query involves the automated discovery of patterns and relationships in a data warehouse.

Accepted Answer

A) True 
 B)False

Question 15

_____ involves eliminating columns in a table.

Accepted Answer

The answer of _____ involves eliminating columns in a table....

Question 16

Developing a seamless integration of databases with the Internet is sometimes called a _____.

Accepted Answer

The answer of Developing a seamless integration of databases with...

Question 17

Climate control is an important component of modern data centers..

Accepted Answer

A) True 
 B)False

Question 18

The specific value of an attribute is called a data entity.

Accepted Answer

A) True 
 B)False

Question 19

As long as the tables in a relational database share one common _____, the tables can be linked to provide useful information and reports.

Accepted Answer

A)  primary key 
B)  file 
C)  characteristic 
D)  attribute

Question 20

A(n) _____ is a simple database program whose records have no relationship to one another.

Accepted Answer

A)  flat file 
B)  schema 
C)  relational system 
D)  user view

Exam 5: Database Systems, Data Centers, and Business Intelligence

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

Big data refers to large amounts of unstructured data from sources such as the Internet, photos, videos, audio, social networks, and sensors that is difficult to capture, store, and manipulate using traditional database management systems.

When organizing a database, key considerations include determining what data to collect, who will have access to it, how they might want to use it, and how to monitor database performance.

The smallest piece of data used by a computer is the _____.

Selecting involves combining two or more tables.

Online Analytical Processing and data mining are essentially the same thing.

A data warehouse stores historical data that has been extracted from operational systems, external sources, and, sometimes, even unique sources.

When creating backup databases, some companies use software to eliminate any duplicated data to save storage capacity and reduce costs, an approach some call data ______ .

The allowable values for an attribute is called its _____.

______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

A database, a database management system, and the application programs that use the data make up a database environment.

Counterintelligence turns data into useful information that then is kept closely guarded to avoid this information from falling into the hands of the wrong employees.

A collection of fields about a specific object is a record.

Data query involves the automated discovery of patterns and relationships in a data warehouse.

_____ involves eliminating columns in a table.

Developing a seamless integration of databases with the Internet is sometimes called a _____.

Climate control is an important component of modern data centers..

The specific value of an attribute is called a data entity.

As long as the tables in a relational database share one common _____, the tables can be linked to provide useful information and reports.

A(n) _____ is a simple database program whose records have no relationship to one another.