MANAGING DATABASES WITH ORACLE QUIZ

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

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?

Open [FileName]

Edit [FileName]

Show [FileName]

Alter [FileName]

TRUE ANSWER : ?
YOUR ANSWER : ?

Of the three ways to create an Oracle database, which one is the easiest and most recommended?

Using the SQL CREATE DATABASE command.

Using the Oracle-supplied database creation procedures.

Using the Oracle Database Configuration Assistant.

None of these

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 : ?

Oracle directly supports the definition of surrogate keys.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Oracle allows the ORDER BY clause in view definitions.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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 : ?

Which SQL phrase is not supported by Oracle?

DROP SEQUENCE [SequenceName]

CREATE SEQUENCE [SequenceName]

ON DELETE CASCADE

ON UPDATE CASCADE

TRUE ANSWER : ?
YOUR ANSWER : ?

What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?

Rollback failure

Media Failure

Instance Failure

Application failure

TRUE ANSWER : ?
YOUR ANSWER : ?

↑