Question 1

In a relational database model, the rows are called _____.

Accepted Answer

A)   tuples
B)   attributes
C)   branches
D)   rootsE) A) and B)
F) A) and C)

Question 2

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

Accepted Answer

Answers will vary.The fragmentation appr...

Question 3

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Accepted Answer

A) True 
 B)False

Question 4

The use of the OR operator in a query form, when using query by example (QBE), means that all conditions must be met.

Accepted Answer

A) True 
 B)False

Question 5

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

Accepted Answer

A)   Data structure
B)   Schema diagrams
C)   Integrity rules
D)   File procedureE) B) and C)
F) A) and D)

Question 6

Which of the following statements is true of distributed databases?

Accepted Answer

A)   They store data on one central server in an organization.
B)   They are limited by the data's physical location.
C)   In distributed databases, local storage of data increases response time.
D)   In distributed databases, local storage of data increases communication costs.E) A) and B)
F) A) and C)

Question 7

Explain the function of the data definition component of a database management system.

Accepted Answer

Answers will vary.The data definition co...

Question 8

A data hierarchy_____is the structure and organization of data, which involves fields, records, and files. ​

Accepted Answer

A)   data hierarchy
B)   data mart
C)   data warehouse
D)   data mineE) B) and D)
F) C) and D)

Question 9

In the context of data models, relationships among records in a hierarchical model are called _____.

Accepted Answer

A)   nodes
B)   branches
C)   roots
D)   segmentsE) None of the above
F) A) and C)

Question 10

In comparison with flat file systems, databases:

Accepted Answer

A)   minimize data redundancy.
B)   are easier to design.
C)   have less sophisticated security measures.
D)   require more storage space.E) A) and B)
F) A) and C)

Question 11

Describe the features and benefits of an object-oriented database.

Accepted Answer

Answers will vary.Like object-oriented p...

Question 12

Business intelligence (BI) uses scorecards and dashboards to support decision-making activities, whereas business analytics (BA) uses data mining tools and predictive modeling.

Accepted Answer

A) True 
 B)False

Question 13

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

Accepted Answer

A)   predictive modeling
B)   dashboards
C)   query reports
D)   application generatorsE) A) and B)
F) A) and C)

Question 14

In large organizations, database design and management is handled by a _____. ​

Accepted Answer

A)   database administrator
B)   database evaluator
C)   database synchronizer
D)   database developerE) B) and C)
F) C) and D)

Question 15

Disks are sequential access devices, whereas tapes are random access devices.

Accepted Answer

A) True 
 B)False

Question 16

In a _____, the relationships among records form a treelike structure. ​

Accepted Answer

A)   hierarchical model
B)   relational model
C)   network model
D)   spiral modelE) A) and B)
F) None of the above

Question 17

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is an advantage of a database over a flat file system?

Accepted Answer

A)   Hardware and software start-up costs are low when using a database.
B)   A database is simple and easy to design.
C)   Programs and data are interdependent in a database.
D)   A database uses more sophisticated security measures.E) A) and D)
F) B) and C)

Question 19

Data warehouses are sometimes called hypercubes because they _____.

Accepted Answer

A)   are function oriented
B)   store multidimensional data
C)   capture raw transaction data
D)   manage transactionsE) B) and C)
F) A) and B)

Question 20

Which of the following approaches to set up a distributed database management system (DDBMS)  combines the fragmentation approach and the replication approach?

Accepted Answer

A)   The optimization approach
B)   The allocation approach
C)   The encapsulation approach
D)   The normalization approachE) All of the above
F) C) and D)

Exam 3: Database Systems, Data Warehouses and Data Marts

In a _____, the relationships among records form a treelike structure. ​

Correct AnswerverifiedShow Answer

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

Correct AnswerverifiedShow Answer

In comparison with flat file systems, databases:

Correct AnswerverifiedShow Answer

Business intelligence (BI) uses scorecards and dashboards to support decision-making activities, whereas business analytics (BA) uses data mining tools and predictive modeling.

Correct AnswerverifiedShow Answer

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Correct AnswerverifiedShow Answer

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Correct AnswerverifiedShow Answer

Describe the features and benefits of an object-oriented database.

Correct AnswerverifiedAnswers will vary.Like object-oriented p...View AnswerShow Answer

A data hierarchy_____is the structure and organization of data, which involves fields, records, and files. ​

Correct AnswerverifiedShow Answer

Which of the following approaches to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?

Correct AnswerverifiedShow Answer

Explain the function of the data definition component of a database management system.

Correct AnswerverifiedAnswers will vary.The data definition co...View AnswerShow Answer

The use of the OR operator in a query form, when using query by example (QBE), means that all conditions must be met.

Correct AnswerverifiedShow Answer

Which of the following statements is true of distributed databases?

Correct AnswerverifiedShow Answer

In the context of data models, relationships among records in a hierarchical model are called _____.

Correct AnswerverifiedShow Answer

Disks are sequential access devices, whereas tapes are random access devices.

Correct AnswerverifiedShow Answer

In a relational database model, the rows are called _____.

Correct AnswerverifiedShow Answer

Which of the following is an advantage of a database over a flat file system?

Correct AnswerverifiedShow Answer

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

Correct AnswerverifiedAnswers will vary.The fragmentation appr...View AnswerShow Answer

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

Correct AnswerverifiedShow Answer

In large organizations, database design and management is handled by a _____. ​

Correct AnswerverifiedShow Answer

Data warehouses are sometimes called hypercubes because they _____.

Correct AnswerverifiedShow Answer

In a _____, the relationships among records form a treelike structure.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary.Like object-oriented p...
View Answer

A data hierarchy_____is the structure and organization of data, which involves fields, records, and files.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary.The data definition co...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary.The fragmentation appr...
View Answer

Correct Answer
verified

In large organizations, database design and management is handled by a _____.

Correct Answer
verified

Correct Answer
verified