MANAGING DATABASES WITH ORACLE QUIZ

True

False

NextVal and CurrVal are both sequence methods.

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

Sequences guarantee valid surrogate key values.

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

Show [FileName]

Alter [FileName]

Open [FileName]

Edit [FileName]

DESC TABLE [TableName].

DESCRIBE STRUCTURE [TableName].

STRUCTURE [TableName].

DESCRIBE [TableName].

True

False

must always be in lower case.

must always be in upper case.

are case sensitive.

are case insensitive.

is a value that keeps track of explicit locks.

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

is incremented whenever a deadlock occurs.

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

Media Failure

Instance Failure

Rollback failure

Application failure

True

False

True

False