Exam 8: Physical Database Design and Database Infrastructure

Efficient database structures will be beneficial only if queries and the underlying database management system are tuned to properly use the structures.

With ________, the database itself is lost, destroyed, or cannot be read.

Why would you want to override automatic query optimization?

A contiguous section of disk storage space is called a(n):

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

One objective of selecting a data type is to minimize storage space.

VarChar2 would be appropriate for a user that wanted a text datatype for LastName that would only consume the required space.

Vertical partitioning means distributing the columns of a table into several separate physical tables.

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

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.

A credit-card sized plastic card with an embedded microprocessor chip with the ability to store, process, and output electronic data in a secure manner is called a(n):

ACID support for database-as-a-service is easily provided in a cloud computing environment.

An audit trail of database changes is kept by a:

Horizontal partitioning is very different from creating a supertype/subtype relationship.

In most cases, the goal of ________ dominates the design process.

Fast data retrieval is one factor to consider when choosing a file organization for a particular database file.

A key component of the Sarbanes-Oxley Act was enacted to ensure the integrity of IT infrastructure in use within an organization.

All of the following are valid datatypes in Oracle 12c EXCEPT:

A business transaction is a sequence of steps that constitute some well-defined business activity.

Database applications are not very disk intensive.