Managing Databases with Oracle
Which of the following is not true about indexes?

Indexes are created to enable fast retrieval by column values.
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 enforce uniqueness on columns.

ANSWER DOWNLOAD EXAMIANS APP

Managing Databases with Oracle
Which of the following is not true of SQL views?

Oracle views can by queried.
Oracle views cannot use the ORDER BY clause in view definitions.
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.

ANSWER DOWNLOAD EXAMIANS APP

Managing Databases with Oracle
An Oracle System Change Number (SCN):

is a value that is incremented whenever a dirty read occurs.
is a value that keeps track of explicit locks.
is incremented whenever a deadlock occurs.
is a value that is incremented whenever database changes are made.

ANSWER DOWNLOAD EXAMIANS APP