Exam 5: Physical Database Design and Performance

________ can be built into the physical structure of fields for many database management systems.

A(n)________ overrides whatever query plan Oracle would naturally create for a query based upon the query optimizer.

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

Because data table row locations are dictated by the hashing algorithm,only one ________ can be used for hashing-based retrieval.

Discuss the critical decisions that must be made during physical database design.

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

Distributing the rows of data into separate files is called ________.

A disadvantage of partitioning is:

Discuss when it is best to use indexes.

Free range partitioning is a type of horizontal partitioning in which each partition is defined by a range of values for one or more columns in the normalized table.

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

Clustering allows for adjacent secondary memory locations to contain rows from several tables.

Explain the differences between sequential and indexed file organizations.

________ partitioning is a method in which each partition is defined by a range of values for one or more columns of a normalized table.

A factor to consider when choosing a file organization is:

A command used in Oracle to display how the query optimizer intends to access indexes,use parallel servers and join tables to prepare query results is the:

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:

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

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

Explain how one goes about choosing data types.