MANAGING DATABASES WITH ORACLE QUIZ

Oracle does NOT support a CASCADE UPDATE constraint.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Instance Failure

Media Failure

Rollback failure

Application failure

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not true of SQL views?

The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.

Oracle views can by queried.

Oracle views are created using the standard SQL-92 CREATE VIEW command.

Oracle views cannot use the ORDER BY clause in view definitions.

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

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

Edit [FileName]

Show [FileName]

Open [FileName]

Alter [FileName]

TRUE ANSWER : ?
YOUR ANSWER : ?

Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑