Exam 5: Physical Database Design and Performance

While Oracle has responsibility for managing data inside a tablespace,the tablespace as a whole is managed by the:

A table or other data structure used to determine the location of rows in a file that satisfy some condition is called a(n)________.

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

The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.

A tablespace is a named set of disk storage elements in which physical files for the database tables may be stored.

Hash partitioning spreads data evenly across partitions independent of any partition key value.

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

What is a hashing algorithm and how is it used in hashed file organizations?

A default value is the value that a field will always assume,regardless of what the user enters for an instance of that field.

A ________ limits the set of permissible values a field must assume.

A requirement to begin designing physical files and databases is:

A ________ key is one field or a combination of fields for which more than one record may have the same combination of values.

A pointer is a field of data that can be used to locate a related field or record of data.

Security is one advantage of partitioning.

Indexes are most useful for columns that frequently appear in ________ clauses of SQL statements.

A key decision in the physical design process is:

An advantage of partitioning is:

A strategy for breaking apart queries and running each part on separate processors is called ________.

One decision in the physical design process is selecting structures.

Discuss three possible opportunities for denormalization.