Question 1

The process of adding redundancy back into a physical data model is known as denormalization.

Accepted Answer

A) True 
 B)False

Question 2

Joanne, a systems analyst trained at this university, has been asked to lead a team that will recommend a new data storage system for her company. After careful analysis of the five divisions that comprise the entire $35 million company, Joanne's team should recommend a end-user database management system.

Accepted Answer

A) True 
 B)False

Question 3

The Relational DBMS only supports simple data types, but the Object Relational DBMS supports both simple and complex data types.

Accepted Answer

A) True 
 B)False

Question 4

Sequential access files are very efficient for operations such as report writing.

Accepted Answer

A) True 
 B)False

Question 5

Explain the term Volumetrics.

Accepted Answer

The answer of Explain the term Volumetrics....

Question 6

A transaction file is primarily used to update a master file.

Accepted Answer

A) True 
 B)False

Question 7

Normalization is a process that applies a series of rules to a logical data model to determine how well the model is formed.

Accepted Answer

A) True 
 B)False

Question 8

A data model that does not contain repeating fields and that the data models leads to tables containing fields that are dependent on a whole primary key is in _____ normal form.

Accepted Answer

A)  balanced 
B)  first 
C)  primary 
D)  second 
E)  third

Question 9

Summarize the first three steps of the normalization process.

Accepted Answer

The answer of Summarize the first three steps of the...

Question 10

Explain the object persistence format type known as Object Oriented Databases.

Accepted Answer

The answer of Explain the object persistence format type known...

Question 11

Explain the term clustering.

Accepted Answer

The answer of Explain the term clustering....

Question 12

It is difficult to find professionals with the necessary skill set for RDBMS.

Accepted Answer

A) True 
 B)False

Question 13

Finding a specific object in a sequential access file is relatively easy to do.

Accepted Answer

A) True 
 B)False

Question 14

Why should the object persistent classes be dependent on the associated problem domain classes instead of the other way around?

Accepted Answer

The answer of Why should the object persistent classes be...

Question 15

Clustering similar records together is one way of reducing access time.

Accepted Answer

A) True 
 B)False

Question 16

When implementing the object persistence in an ORDBMS, what types of issues must you address?

Accepted Answer

The answer of When implementing the object persistence in an...

Question 17

Denormalization of a data model reduces the number of joins that must be performed in a query, which increases the speed of data access.

Accepted Answer

A) True 
 B)False

Question 18

Up until recently, an object-oriented database is mainly used to support multimedia applications or complex systems involving graphics, video and sound.

Accepted Answer

A) True 
 B)False

Question 19

The leader in the database market and a system that can handle diverse data needs is the relational DBMS.

Accepted Answer

A) True 
 B)False

Question 20

_____ is the process of estimating the amount of data that the hardware will need to support, so that the server hardware specifications are sufficient for the project's needs.

Accepted Answer

A)  Indexing 
B)  Interfile clustering 
C)  Intrafile clustering 
D)  Raw data calculating 
E)  Volumetrics

Exam 9: Data Management Layer Design

The process of adding redundancy back into a physical data model is known as denormalization.

The Relational DBMS only supports simple data types, but the Object Relational DBMS supports both simple and complex data types.

Sequential access files are very efficient for operations such as report writing.

Explain the term Volumetrics.

A transaction file is primarily used to update a master file.

Normalization is a process that applies a series of rules to a logical data model to determine how well the model is formed.

A data model that does not contain repeating fields and that the data models leads to tables containing fields that are dependent on a whole primary key is in _____ normal form.

Summarize the first three steps of the normalization process.

Explain the object persistence format type known as Object Oriented Databases.

Explain the term clustering.

It is difficult to find professionals with the necessary skill set for RDBMS.

Finding a specific object in a sequential access file is relatively easy to do.

Why should the object persistent classes be dependent on the associated problem domain classes instead of the other way around?

Clustering similar records together is one way of reducing access time.

When implementing the object persistence in an ORDBMS, what types of issues must you address?

Denormalization of a data model reduces the number of joins that must be performed in a query, which increases the speed of data access.

Up until recently, an object-oriented database is mainly used to support multimedia applications or complex systems involving graphics, video and sound.

The leader in the database market and a system that can handle diverse data needs is the relational DBMS.

_____ is the process of estimating the amount of data that the hardware will need to support, so that the server hardware specifications are sufficient for the project's needs.