MANAGING DATABASES WITH ORACLE QUIZ

Oracle views can by queried.

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

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.

False

True

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

Sequences guarantee valid surrogate key values.

NextVal and CurrVal are both sequence methods.

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

True

False

DESC TABLE [TableName].

STRUCTURE [TableName].

DESCRIBE STRUCTURE [TableName].

DESCRIBE [TableName].

CREATE SEQUENCE [SequenceName]

ON UPDATE CASCADE

ON DELETE CASCADE

DROP SEQUENCE [SequenceName]

are case sensitive.

must always be in lower case.

must always be in upper case.

are case insensitive.

True

False

Consistent backup

Inconsistent backup

Differential backup

Full backup

Control file

Offline ReDo file

OnLine ReDo file

Datafile