MANAGING DATABASES WITH ORACLE QUIZ

You can use the DROP statement to remove structures from the database.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Media Failure

Instance Failure

Rollback failure

Application failure

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not true of SQL views?

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

Oracle views can by queried.

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

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

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

Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

A period ( . ) followed by [Enter].

A semicolon ( ; ) followed by [Enter].

A colon ( : ) followed by [Enter].

A left slash ( ) followed by [Enter].

TRUE ANSWER : ?
YOUR ANSWER : ?

Which prefixes are available to Oracle triggers?

:old only

Neither :new nor :old

:new only

Both :new and :old

TRUE ANSWER : ?
YOUR ANSWER : ?

An Oracle System Change Number (SCN):

is incremented whenever a deadlock occurs.

is a value that keeps track of explicit locks.

is a value that is incremented whenever a dirty read occurs.

is a value that is incremented whenever database changes are made.

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

SQL*Plus is a text editor.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?