MANAGING DATABASES WITH ORACLE QUIZ

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.

True

False

True

False

True

False

Using the Oracle Database Configuration Assistant.

Using the SQL CREATE DATABASE command.

None of these

Using the Oracle-supplied database creation procedures.

Full backup

Inconsistent backup

Differential backup

Consistent backup

DESC TABLE [TableName].

DESCRIBE STRUCTURE [TableName].

DESCRIBE [TableName].

STRUCTURE [TableName].

Open [FileName]

Alter [FileName]

Show [FileName]

Edit [FileName]

True

False

False

True