MANAGING DATABASES WITH ORACLE QUIZ

True

False

True

False

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 can by queried.

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

True

False

:new only

Neither :new nor :old

Both :new and :old

:old only

False

True

AFTER

DURING

BEFORE

INSTEAD OF

You can increase the number of characters in character columns or the number of digits in numeric columns

You cannot increase or decrease the number of decimal places.

You can add a column at any time as long as it is a NULL column.

You can drop a column at any time.

Sequences are most often used to provide values for surrogate keys.

Sequences guarantee valid surrogate key values.

A sequence is an object that generates a sequential series of unique numbers.

NextVal and CurrVal are both sequence methods.

False

True