MANAGING DATABASES WITH ORACLE QUIZ

False

True

False

True

True

False

BUFFER

CONTENTS

LIST

CURRENT

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

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

Oracle views can by queried.

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

BEFORE

AFTER

DURING

INSTEAD OF

False

True

False

True

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.

Indexes are created with the ALTER TABLE command.

is a value that keeps track of explicit locks.

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

is incremented whenever a deadlock occurs.

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