Chapter 5

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

Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.

The value a field will assume unless the user enters an explicit value for an instance of that field is called a(n):

Security is one advantage of partitioning.

Requirements for response time, data security, backup and recovery are all requirements for physical design.

One objective of selecting a data type is to minimize storage space.

One method to handle missing values is to substitute an exact value.

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

Keeping the zip code with the city and state in a table is a typical form of denormalization.

Indexes are most useful on small, clustered files.

Indexes are most useful for columns that frequently appear in WHERE clauses of SQL commands, either to qualify the row to select or for linking

In a sequential file, the records are stored in sequence according to primary key.

Horizontal partitioning makes sense:

Horizontal partitioning refers to the process of combining several smaller relations into a larger table.

Distributing the rows of data into separate files is called:

Denormalization is the process of transforming relations with variable-length fields into those with fixed-length fields.

An advantage of partitioning is:

A range control limits the set of permissible values that a field may assume.

A(n)____ is a technique for physically arranging the records of a file on secondary storage devices.

Denormalization almost always leads to more storage space for raw data.