MANAGING DATABASES WITH ORACLE QUIZ

False

True

True

False

True

False

Consistent backup

Inconsistent backup

Full backup

Differential backup

Indexes are created with the ALTER TABLE command.

Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.

Indexes are created to enable fast retrieval by column values.

Indexes are created to enforce uniqueness on columns.

Sequences guarantee valid surrogate key values.

A sequence is an object that generates a sequential series of unique numbers.

Sequences are most often used to provide values for surrogate keys.

NextVal and CurrVal are both sequence methods.

False

True

is incremented whenever a deadlock occurs.

is a value that is incremented whenever database changes are made.

is a value that keeps track of explicit locks.

is a value that is incremented whenever a dirty read occurs.

OnLine ReDo file

Control file

Datafile

Offline ReDo file

Oracle views cannot use the ORDER BY clause in view definitions.

The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.

Oracle views are created using the standard SQL-92 CREATE VIEW command.

Oracle views can by queried.