MANAGING DATABASES WITH ORACLE QUIZ

SQL*Plus will finish the statement and execute it when the user types in this:

A left slash ( ) followed by [Enter].

A colon ( : ) followed by [Enter].

A period ( . ) followed by [Enter].

A semicolon ( ; ) followed by [Enter].

TRUE ANSWER : ?
YOUR ANSWER : ?

Which SQL phrase is not supported by Oracle?

ON DELETE CASCADE

ON UPDATE CASCADE

CREATE SEQUENCE [SequenceName]

DROP SEQUENCE [SequenceName]

TRUE ANSWER : ?
YOUR ANSWER : ?

The semicolon terminates a SQL statement (and executes it).

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

When you type into SQL*Plus and press enter, the statement will be finished and executed.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

To see the contents of the SQL*Plus buffer, type:

LIST

CONTENTS

BUFFER

CURRENT

TRUE ANSWER : ?
YOUR ANSWER : ?

The only time that case matters is inside quotation marks of strings.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Sequences guarantee valid surrogate key values.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

When you type Start FILENAME, the statement in your file will be executed automatically.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is NOT an Oracle-supported trigger?

DURING

INSTEAD OF

AFTER

BEFORE

TRUE ANSWER : ?
YOUR ANSWER : ?

You have linked SQLPlus to an external text editor. To invoke the text editor for use within SQLPlus, which command do you use?

Alter [FileName]

Open [FileName]

Show [FileName]

Edit [FileName]

TRUE ANSWER : ?
YOUR ANSWER : ?

↑