Question 1

In the context of data warehouses, briefly explain extraction, transformation, and loading (ETL).

Accepted Answer

Answers will vary.ETL refers to the proc...

Question 2

In a relational database model, a(n)  _____ searches data in a table and retrieves records based on certain criteria.

Accepted Answer

A)   insert operation
B)   join operation
C)   find operation
D)   select operationE) B) and C)
F) None of the above

Question 3

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

Accepted Answer

A)   data dictionary
B)   data mine
C)   data warehouse
D)   data martE) A) and D)
F) A) and C) A

Question 4

Which of the following is a key factor that has contributed to the growth and popularity of big data?

Accepted Answer

A)   Implosion in data growth
B)   Brick and mortar businesses
C)   Mobile and wireless technology
D)   Exponential decay of organizational dataE) None of the above
F) A) and B)

Question 5

Briefly discuss the advantages and disadvantages of database marketing.

Accepted Answer

Answers will vary.Database marketing off...

Question 6

Discuss why an organization might choose a distributed database.

Accepted Answer

Answers will vary.A distributed database...

Question 7

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

Accepted Answer

A)   network model
B)   hierarchical model
C)   object-oriented model
D)   relational modelE) B) and D)
F) A) and B)

Question 8

In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

Accepted Answer

A)   extraction
B)   transformation
C)   optimization
D)   aggregationE) A) and C)
F) B) and C)

Question 9

The _____ component of a database management system (DBMS)  is used for tasks such as backup and recovery, security, and change management.

Accepted Answer

A)   data manipulation
B)   data generation
C)   data definition
D)   data administrationE) C) and D)
F) B) and D) D

Question 10

Which of the following statements is true of a database?

Accepted Answer

A)   It allows more than one program to use the same data.
B)   It comprises data that cannot be linked.
C)   It consists of a segregated set of files.
D)   It is a crucial tool for managing overseas subsidiaries.E) A) and D)
F) B) and C)

Question 11

Briefly explain the types of business analytics (BA) methods.

Accepted Answer

Answers will vary.There are several type...

Question 12

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

Accepted Answer

A)   velocity
B)   volume
C)   area
D)   timeE) B) and D)
F) B) and C)

Question 13

When using query by example (QBE)  in the data manipulation component of a database management system (DBMS) , the _____ is used when all the conditions in the QBE form must be met.

Accepted Answer

A)   NOT operator
B)   AND operator
C)   OR operator
D)   NOR operatorE) All of the above
F) A) and B) B

Question 14

In the context of the data manipulation component of a database management system (DBMS), briefly explain structured query language (SQL).

Accepted Answer

Answers will vary.The data manipulation ...

Question 15

Discuss the advantages of a database over a flat file system.

Accepted Answer

Answers will vary.A database has the fol...

Question 16

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 administrationE) C) and D)
F) A) and B)

Question 17

Which of the following statements is true of a flat file system?

Accepted Answer

A)   Same data can be stored in more than one file.
B)   Programs and data are independent.
C)   Complex requests can be handled easily.
D)   It requires very less storage space.E) B) and C)
F) A) and C)

Question 18

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Accepted Answer

A) True 
 B)False

Question 19

Describe how data stored in a relational model is retrieved from tables.

Accepted Answer

Answers will vary.Data stored in a relat...

Question 20

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Accepted Answer

A) True 
 B)False

Exam 3: Database Systems, Data Warehouses and Data Marts

In the context of data warehouses, briefly explain extraction, transformation, and loading (ETL).

Correct AnswerverifiedAnswers will vary.ETL refers to the proc...View AnswerShow Answer

In a relational database model, a(n) _____ searches data in a table and retrieves records based on certain criteria.

Correct AnswerverifiedShow Answer

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

Correct AnswerverifiedA

Which of the following is a key factor that has contributed to the growth and popularity of big data?

Correct AnswerverifiedShow Answer

Briefly discuss the advantages and disadvantages of database marketing.

Correct AnswerverifiedAnswers will vary.Database marketing off...View AnswerShow Answer

Discuss why an organization might choose a distributed database.

Correct AnswerverifiedAnswers will vary.A distributed database...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

Correct AnswerverifiedShow Answer

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery, security, and change management.

Correct AnswerverifiedD

Which of the following statements is true of a database?

Correct AnswerverifiedShow Answer

Briefly explain the types of business analytics (BA) methods.

Correct AnswerverifiedAnswers will vary.There are several type...View AnswerShow Answer

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

Correct AnswerverifiedShow Answer

When using query by example (QBE) in the data manipulation component of a database management system (DBMS) , the _____ is used when all the conditions in the QBE form must be met.

Correct AnswerverifiedB

In the context of the data manipulation component of a database management system (DBMS), briefly explain structured query language (SQL).

Correct AnswerverifiedAnswers will vary.The data manipulation ...View AnswerShow Answer

Discuss the advantages of a database over a flat file system.

Correct AnswerverifiedAnswers will vary.A database has the fol...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

Which of the following statements is true of a flat file system?

Correct AnswerverifiedShow Answer

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Correct AnswerverifiedShow Answer

Describe how data stored in a relational model is retrieved from tables.

Correct AnswerverifiedAnswers will vary.Data stored in a relat...View AnswerShow Answer

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Correct AnswerverifiedShow Answer

Correct Answer
verified
Answers will vary.ETL refers to the proc...
View Answer

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified
Answers will vary.Database marketing off...
View Answer

Correct Answer
verified
Answers will vary.A distributed database...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified
Answers will vary.There are several type...
View Answer

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified
Answers will vary.The data manipulation ...
View Answer

Correct Answer
verified
Answers will vary.A database has the fol...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary.Data stored in a relat...
View Answer

Correct Answer
verified