MANAGING DATABASES WITH ORACLE QUIZ

A semicolon ( ; ) followed by [Enter].

A left slash ( ) followed by [Enter].

A period ( . ) followed by [Enter].

A colon ( : ) followed by [Enter].

True

False

Both :new and :old

Neither :new nor :old

:new only

:old only

is a value that is incremented whenever a dirty read occurs.

is a value that is incremented whenever database changes are made.

is incremented whenever a deadlock occurs.

is a value that keeps track of explicit locks.

CREATE SEQUENCE [SequenceName]

ON DELETE CASCADE

DROP SEQUENCE [SequenceName]

ON UPDATE CASCADE

True

False

True

False

False

True

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

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

You can drop a column at any time.

You cannot increase or decrease the number of decimal places.

Open [FileName]

Edit [FileName]

Alter [FileName]

Show [FileName]