Exam 5: Physical Database Design and Performance

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:

All of the following are valid datatypes in Oracle 11g EXCEPT:

Explain what primary, secondary and unique key indexes are.

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 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:

Horizontal partitioning makes sense:

A hashing algorithm is a routine that converts a primary key value into a relative record number.

Discuss the advantages and disadvantages of partitioning.

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

Parallel query processing speed is not significantly different from running queries in a non-parallel mode.

In which data model would a code table appear?

A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called:

Explain what a tablespace is and how it is used.

Explain the differences between sequential and indexed file organizations.

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

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

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

What is clustering?

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

Database access frequencies are estimated from: