MANAGING DATABASES WITH ORACLE QUIZ

ALTER TABLE [TableName].

CHANGE TABLE [TableName].

UPDATE TABLE [TableName].

MODIFY TABLE [TableName].

To see the errors, enter SHOW ERRORS in SQL*Plus.

If there are no syntax errors, you will receive the message "NO ERRORS."

SQL*Plus will automatically show the errors to you.

The line numbers reported match the line numbers you see in your text editor.

False

True

True

False

Both :new and :old

Neither :new nor :old

:old only

:new only

True

False

True

False

False

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.

False

True