Chapter 5 Quiz

Which of the following is an objective of selecting a data type?

Improve data integrity

A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a:

hash index table.

An appropriate datatype for adding a sound clip would be:

Blob

An appropriate datatype for one wanting a fixed-length type for last name would include:

Char

Which type of file is most efficient with storage space?

Sequential

________ partitioning distributes the columns of a table into several separate physical records.

Vertical

All of the following are common denormalization opportunities EXCEPT:

a one-to-many relationship.

A form of denormalization where the same data are purposely stored in multiple places in the database is called:

data replication

Designing physical files requires ________ of where and when data are used in various ways.

descriptions

A contiguous section of disk storage space is called a(n):

extent

A disadvantage of partitioning is:

extra space and update time.

The smallest unit of application data recognized by system software is a:

field

A(n) ________ is a routine that converts a primary key value into a relative record number.

hashing algorithm

An index on columns from two or more tables that come from the same domain of values is called a:

join index.

A requirement to begin designing physical files and databases is:

normalized relations.

A(n) ________ is a field of data used to locate a related field or record.

pointer

One field or combination of fields for which more than one record may have the same combination of values is called a(n):

secondary key

Database access frequencies are estimated from:

transaction volumes.

All of the following are objectives when selecting a data type EXCEPT:

use a lot of storage space.

Horizontal partitioning makes sense:

when different categories of a table's rows are processed separately.