Chapter 8: Database Management

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:

Explain plan

Indexes are most useful on small, clustered files. (T/F)

False

The record log is a record of the essential data for each transaction that has been processed against the database. (T/F)

False

Three-factor authentication is most often implemented with a credit card. (T/F)

False

Which type of fie is easiest to update?

Hashed

Sarbanes-Oxley Act was enacted to ensure the integrity of:

Public companies' financial statements.

An integrity control supported by a DBMS is:

Range Control

A cloud computing approach in which the service consists of software solutions intended to address the needs of a noncompeting activity is called:

Software-as-a-service.

A discrete unit of work that must be processed completely or not at all within a computer system is called a:

Transaction

A range control limits the set of permissible values that a field may assume. (T/F)

True

Hash partitioning spreads data evenly across partitions independent of any partition key value. (T/F)

True

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. (T/F)

True

Live migration from one environment to another in cloud computing is a challenge. (T/F)

True

Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results. (T/F)

True

The restore/rerun technique involves reprocessing the day's transactions against the backup copy of the database. (T/F)

True

VarChar2 Would be appropriate for a user that wanted a text datatype for LastName that would only consume the required space. (T/F)

True

With a one-key encryption standard, both the sender and the receiver need to know the key that is used to scramble the transmitted or stored data. (T/F)

True

________ partitioning distributes the columns of a table into several separate physical records.

Vertical

All of the following are common denormalization opportunities EXCEPT:

a one-to-many relationship.

A DBMS periodically suspends all processing and synchronizes its files and journals through the use of a:

checkpoint facility

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

data replication

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

efficient data processing

Distributing the rows of data into separate files is called:

horizontal partitioning

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

operating system

In which data model would a code table appear

physical

A(n) ________ is a field of data used to locate a related field or record.

pointer