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

The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
Oracle views are created using the standard SQL-92 CREATE VIEW command.
Oracle views cannot use the ORDER BY clause in view definitions.
Oracle views can by queried.

ANSWER DOWNLOAD EXAMIANS APP

Managing Databases with Oracle
Which statement about sequences is not true?

A sequence is an object that generates a sequential series of unique numbers.
NextVal and CurrVal are both sequence methods.
Sequences are most often used to provide values for surrogate keys.
Sequences guarantee valid surrogate key values.

ANSWER DOWNLOAD EXAMIANS APP

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

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.
is a value that keeps track of explicit locks.

ANSWER DOWNLOAD EXAMIANS APP