Question 1

A database administrator is responsible for _____.

Accepted Answer

A)  developing recovery procedures in case data is lost or corrupted
B)  maintaining (keeping) an organization's computer network up to date
C)  writing computer programs that allow the system to perform a specific task
D)  designing and implementing the information systems

Question 2

_________ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

Accepted Answer

A)  Online transaction processing (OLTP) 
B)  Online analytical processing (OLAP) 
C)  Extraction,transformation,and loading (ETL) 
D)  Business analytics (B
A)

Question 3

The _____ component of a database management system (DBMS) is used to add,delete,modify,and retrieve records from a database.

Accepted Answer

A)  data manipulation
B)  data generation
C)  data definition
D)  data administration

Question 4

A _________ is a collection of related data that is stored in a central location or multiple locations.

Accepted Answer

A)  database
B)  data mart
C)  data warehouse
D)  data hierarchy​

Question 5

Identify an advantage of using a database over a flat file system.

Accepted Answer

A)  Hardware and software start-up costs are low.
B)  It is simple and easy to design.
C)  Programs and data are interdependent.
D)  It uses more sophisticated security measures.

Question 6

The variety dimension of big data refers to a combination of _____.

Accepted Answer

A)  data warehouses and data marts
B)  raw data and metadata
C)  structured data and unstructured data
D)  data definition and data manipulation

Question 7

What is the function of a distributed database management system (DDBMS)?

Accepted Answer

A distributed database managem...

Question 8

Identify a true statement about a flat file system.

Accepted Answer

A)  Data in a flat file system may not be updated in all files consistently.
B)  Data in a flat file system can be easily managed.
C)  Data in a flat file system can be updated efficiently.
D)  Data duplication in a flat file system is very efficient.

Question 9

Which of the following data sources provides the input a data warehouse needs to perform analyses and generate reports?

Accepted Answer

A)  Online analytical processing systems
B)  Online transaction processing systems
C)  Enterprise resource planning systems
D)  Data mining analysis systems

Question 10

An advantage that a database has over a flat file system is that more information can be generated from the same data.

Accepted Answer

A) True 
 B)False

Question 11

What are the areas in the retail industry that can benefit from big data?

Accepted Answer

The retail industry could benefit from b...

Question 12

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Accepted Answer

A) True 
 B)False

Question 13

List and describe the features of data in a data warehouse in contrast to data in a database.

Accepted Answer

Data in a data warehouse is described as...

Question 14

The use of the OR operator means that only one of the conditions in a structured query language (SQL)statement must be met.

Accepted Answer

A) True 
 B)False

Question 15

Business intelligence uses scorecards and query reports to support decision-making activities,whereas business analytics uses data mining tools and predictive modeling.

Accepted Answer

A) True 
 B)False

Question 16

In a(n) _____ model,each record can have multiple parent and child records.

Accepted Answer

A)  network
B)  hierarchical
C)  object-oriented
D)  relational

Question 17

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

Accepted Answer

A) True 
 B)False

Question 18

Explain the ways in which information in a database is observed through a physical view.

Accepted Answer

The physical view involves how...

Question 19

In a relational database model,the columns are known as _____.

Accepted Answer

A)  attributes
B)  tuples
C)  branches
D)  roots

Question 20

What is a data-driven Web site?

Accepted Answer

A data-driven Web site acts as...

Exam 3: Database Systems,Data Warehouses,and Data Marts

A database administrator is responsible for _____.

Correct AnswerverifiedShow Answer

An advantage that a database has over a flat file system is that more information can be generated from the same data.

Correct AnswerverifiedShow Answer

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Correct AnswerverifiedShow Answer

_________ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

Correct AnswerverifiedShow Answer

The use of the OR operator means that only one of the conditions in a structured query language (SQL)statement must be met.

Correct AnswerverifiedShow Answer

Business intelligence uses scorecards and query reports to support decision-making activities,whereas business analytics uses data mining tools and predictive modeling.

Correct AnswerverifiedShow Answer

A _________ is a collection of related data that is stored in a central location or multiple locations.

Correct AnswerverifiedShow Answer

The variety dimension of big data refers to a combination of _____.

Correct AnswerverifiedShow Answer

Identify an advantage of using a database over a flat file system.

Correct AnswerverifiedShow Answer

What are the areas in the retail industry that can benefit from big data?

Correct AnswerverifiedThe retail industry could benefit from b...View AnswerShow Answer

The _____ component of a database management system (DBMS) is used to add,delete,modify,and retrieve records from a database.

Correct AnswerverifiedShow Answer

What is a data-driven Web site?

Correct AnswerverifiedA data-driven Web site acts as...View AnswerShow Answer

Which of the following data sources provides the input a data warehouse needs to perform analyses and generate reports?

Correct AnswerverifiedShow Answer

List and describe the features of data in a data warehouse in contrast to data in a database.

Correct AnswerverifiedData in a data warehouse is described as...View AnswerShow Answer

In a(n) _____ model,each record can have multiple parent and child records.

Correct AnswerverifiedShow Answer

What is the function of a distributed database management system (DDBMS)?

Correct AnswerverifiedA distributed database managem...View AnswerShow Answer

In a relational database model,the columns are known as _____.

Correct AnswerverifiedShow Answer

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

Correct AnswerverifiedShow Answer

Identify a true statement about a flat file system.

Correct AnswerverifiedShow Answer

Explain the ways in which information in a database is observed through a physical view.

Correct AnswerverifiedThe physical view involves how...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The retail industry could benefit from b...
View Answer

Correct Answer
verified

Correct Answer
verified
A data-driven Web site acts as...
View Answer

Correct Answer
verified

Correct Answer
verified
Data in a data warehouse is described as...
View Answer

Correct Answer
verified

Correct Answer
verified
A distributed database managem...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The physical view involves how...
View Answer