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