MANAGING DATABASES WITH ORACLE QUIZ

Which prefixes are available to Oracle triggers?

:old only

Neither :new nor :old

Both :new and :old

:new only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

A left slash ( ) followed by [Enter].

A period ( . ) followed by [Enter].

A semicolon ( ; ) followed by [Enter].

A colon ( : ) followed by [Enter].

TRUE ANSWER : ?
YOUR ANSWER : ?

If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

are case sensitive.

must always be in lower case.

are case insensitive.

must always be in upper case.

TRUE ANSWER : ?
YOUR ANSWER : ?

In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

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

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

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

SQL*Plus will automatically show the errors to you.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

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?

Show [FileName]

Alter [FileName]

Edit [FileName]

Open [FileName]

TRUE ANSWER : ?
YOUR ANSWER : ?

Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which SQL phrase is not supported by Oracle?

DROP SEQUENCE [SequenceName]

ON UPDATE CASCADE

ON DELETE CASCADE

CREATE SEQUENCE [SequenceName]

TRUE ANSWER : ?
YOUR ANSWER : ?