Question 1

Discuss why an organization might choose a distributed database.

Accepted Answer

Answers will vary.A distributed database...

Question 2

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 3

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) All of the above
F) A) and C)

Question 4

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

Accepted Answer

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

Question 5

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

Question 6

Briefly discuss the advantages and disadvantages of database marketing.

Accepted Answer

Answers will vary.Database marketing off...

Question 7

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) A) and D)
F) All of the above D

Question 8

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) None of the above
F) C) and D) A

Question 9

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

Accepted Answer

Answers will vary.There are several type...

Question 10

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

Question 11

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) A) and B)
F) None of the above

Question 12

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

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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) None of the above
F) B) and D) B

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) A) and B)
F) All of the above

Question 17

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) None of the above
F) All of the above

Question 18

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

Question 19

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

Question 20

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

Accepted Answer

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

Exam 3: Database Systems, Data Warehouses and Data Marts

Discuss why an organization might choose a distributed database.

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

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

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

Correct AnswerverifiedShow Answer

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 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

Briefly discuss the advantages and disadvantages of database marketing.

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

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

Correct AnswerverifiedD

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

Correct AnswerverifiedA

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow 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

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

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

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following statements is true of a database?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedAnswers will vary.A database has the fol...View AnswerShow Answer

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
D

Correct Answer
verified
A

Correct Answer
verified
Answers will vary.There are several type...
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

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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