MANAGING DATABASES WITH ORACLE QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Oracle does NOT support a CASCADE UPDATE constraint.

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

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

Differential backup

Full backup

Inconsistent backup

Consistent backup

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Rollback failure

Instance Failure

Application failure

Media Failure

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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]

Edit [FileName]

Open [FileName]

Show [FileName]

TRUE ANSWER : ?
YOUR ANSWER : ?

Oracle allows the ORDER BY clause in view definitions.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑