Exam 8: Physical Database Design and Database Infrastructure

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

A key decision in the physical design process is:

Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):

Live migration from one environment to another in cloud computing is a challenge.

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

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

Loss of data integrity does not impact the quality of data in a database.

Discuss why physical database design is a foundation for compliance with regulations on financial reporting.

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

The first line of defense for authentication is the use of passwords, which is a one-factor authentication scheme.

What is backward and forward recovery?

An integrity control supported by a DBMS is:

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

________ is used to undo unwanted database changes.

A file organization where files are not stored in any particular order is considered a:

What are integrity controls? Describe the different types.

Explain how one goes about choosing data types.

The transaction log contains before and after images of records that have been modified.

A key is a data structure used to determine the location of rows in a file that satisfy some condition.

The record log is a record of the essential data for each transaction that has been processed against the database.