MANAGING DATABASES WITH ORACLE QUIZ

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.

False

True

STRUCTURE [TableName].

DESCRIBE [TableName].

DESCRIBE STRUCTURE [TableName].

DESC TABLE [TableName].

False

True

False

True

SQL*Plus will automatically show the errors to you.

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

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

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

Datafile

Offline ReDo file

Control file

OnLine ReDo file

True

False

False

True

False

True