Exam 5: Physical Database Design and Performance

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

All of the following are horizontal partitioning methods in Oracle EXCEPT:

Why would you want to override automatic query optimization?

A disadvantage of partitioning is:

An extent is a named portion of secondary memory allocated for the purpose of storing physical records.

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

Reduced uptime is a disadvantage of partitioning.

How are missing values generally handled in database management systems?

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

A detailed coding scheme recognized by system software for representing organizational data is called a(n):

List the seven factors to consider when choosing a file organization for a particular file in a database.

In a Heap file organization, files are not stored in any particular order:

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

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

In which type of file is multiple key retrieval not possible?

The smallest unit of named application data is a record.

A method to allow adjacent secondary memory space to contain rows from several tables is called:

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

One decision in the physical design process is selecting structures.

Discuss the rationale behind data volume and usage analysis.