mod 6

Question 1

Assumed value if no explicit value is available.

Answer 1

Default Value

Question 2

A control mechanism that will either allow or prohibit empty field values.

Answer 2

Null value control

Question 3

The purpose of Physical Database Design is to translate the logical description of data into the technical specifications for storing and retrieving data.

Answer 3

True

Question 4

Denormalization will not introduce anomalies restricted by normalization.

Answer 4

False

Question 5

To handle missing data in a database, an estimated substitute value may be used to fill it.

Answer 5

True

Question 6

A database control mechanism that manages allowable field data values.

Answer 6

Range control

Question 7

Denormalization may improve performance by decreasing the number of table lookups compare to a normalized database.

Answer 7

True

Question 8

Denormalization can decrease the chance of errors and inconsistencies.

Answer 8

False

Question 9

The goal of a Physical Database Design is to create a design for storing data that will provide adequate performance and ensure database integrity, security, and recoverability.

Answer 9

True

Question 10

Storage space will not be wasted in denormalization of a database.

Answer 10

False