Question 1

A database is a collection of integrated and related _____.

Accepted Answer

A)   fields
B)   attributes
C)   records
D)   files D

Question 2

The _____ data model has become the most popular database model.

Accepted Answer

relational

Question 3

With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet.

Accepted Answer

A)   Internet access
B)   Database as a Service
C)   Software as a Service
D)   Oracle B

Question 4

_____ lets programmers learn one powerful query language and use it on systems ranging from PCs to the largest mainframe computers.

Accepted Answer

The answer of _____ lets programmers learn one powerful query...

Question 5

In the relational data model, each row of a table represents a(n) _____.

Accepted Answer

The answer of In the relational data model, each row...

Question 6

A collection of fields all related to a single object, activity, or individual is a(n) _____.

Accepted Answer

A)   record
B)   file
C)   attribute
D)   character

Question 7

One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically.

Accepted Answer

A) True 
 B)False

Question 8

Microsoft built a data center taking up 16 football fields of space filled with 220 shipping containers packed with servers.

Accepted Answer

A) True 
 B)False

Question 9

A ________ is a climate-controlled building or set of buildings that houses database servers and the systems that deliver mission-critical information and services.

Accepted Answer

A)   data warehouse
B)   data center
C)   shipping container
D)   data hierarchy

Question 10

_____ combines historical data with assumptions about future conditions to predict the outcomes of events.

Accepted Answer

A)   Business intelligence
B)   Data mining
C)   Online analytical processing
D)   Predictive analysis

Question 11

Differentiate between the traditional and database approach to data management.

Accepted Answer

The answer of Differentiate between the traditional and database approach...

Question 12

_____ is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events.

Accepted Answer

The answer of _____ is a form of data mining...

Question 13

Define the term data mining and identify its objectives.

Accepted Answer

The answer of Define the term data mining and identify...

Question 14

______ use basic graphical symbols to show the organization of and relationships between data.

Accepted Answer

The answer of ______ use basic graphical symbols to show...

Question 15

_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.

Accepted Answer

A)   Data mining
B)   DBMS
C)   Competitive intelligence
D)   Data loss prevention

Question 16

Briefly describe the hierarchy of data.

Accepted Answer

The answer of Briefly describe the hierarchy of data....

Question 17

A description that tells the DBMS the logical and physical structure of the data and the relationships among the data for each user is called a(n) _____.

Accepted Answer

The answer of A description that tells the DBMS the...

Question 18

A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.

Accepted Answer

The answer of A(n) ______ is an individual responsible for...

Question 19

A collection of related records is called a(n) _____.

Accepted Answer

The answer of A collection of related records is called...

Question 20

A data model is a diagram of data attributes and their relationships.

Accepted Answer

A) True 
 B)False

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

A database is a collection of integrated and related _____.

The _____ data model has become the most popular database model.

With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet.

_____ lets programmers learn one powerful query language and use it on systems ranging from PCs to the largest mainframe computers.

In the relational data model, each row of a table represents a(n) _____.

A collection of fields all related to a single object, activity, or individual is a(n) _____.

One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically.

Microsoft built a data center taking up 16 football fields of space filled with 220 shipping containers packed with servers.

A ________ is a climate-controlled building or set of buildings that houses database servers and the systems that deliver mission-critical information and services.

_____ combines historical data with assumptions about future conditions to predict the outcomes of events.

Differentiate between the traditional and database approach to data management.

_____ is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events.

Define the term data mining and identify its objectives.

______ use basic graphical symbols to show the organization of and relationships between data.

_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.

Briefly describe the hierarchy of data.

A description that tells the DBMS the logical and physical structure of the data and the relationships among the data for each user is called a(n) _____.

A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.

A collection of related records is called a(n) _____.

A data model is a diagram of data attributes and their relationships.