MANAGING DATABASES WITH ORACLE QUIZ

False

True

UPDATE TABLE [TableName].

MODIFY TABLE [TableName].

CHANGE TABLE [TableName].

ALTER TABLE [TableName].

True

False

Using the Oracle-supplied database creation procedures.

None of these

Using the Oracle Database Configuration Assistant.

Using the SQL CREATE DATABASE command.

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.

Alter [FileName]

Open [FileName]

Edit [FileName]

Show [FileName]

DURING

BEFORE

INSTEAD OF

AFTER

True

False

False

True

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

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

is incremented whenever a deadlock occurs.

is a value that keeps track of explicit locks.