MANAGING DATABASES WITH ORACLE QUIZ

ALTER TABLE [TableName].

CHANGE TABLE [TableName].

MODIFY TABLE [TableName].

UPDATE TABLE [TableName].

Open [FileName]

Edit [FileName]

Alter [FileName]

Show [FileName]

Oracle views can by queried.

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 cannot use the ORDER BY clause in view definitions.

STRUCTURE [TableName].

DESCRIBE [TableName].

DESC TABLE [TableName].

DESCRIBE STRUCTURE [TableName].

INSTEAD OF

AFTER

BEFORE

DURING

True

False

Indexes are created to enforce uniqueness on columns.

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

Indexes are created with the ALTER TABLE command.

Indexes are created to enable fast retrieval by column values.

False

True

.txt

.sql

.ora

.pls

True

False