MANAGING DATABASES WITH ORACLE QUIZ

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

Instance Failure

Rollback failure

Media Failure

Application failure

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Money is defined in Oracle with the Currency data type.

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]

Open [FileName]

Edit [FileName]

Alter [FileName]

TRUE ANSWER : ?
YOUR ANSWER : ?

Which prefixes are available to Oracle triggers?

Both :new and :old

Neither :new nor :old

:new only

:old 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 colon ( : ) followed by [Enter].

A semicolon ( ; ) followed by [Enter].

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 cannot use the ORDER BY clause in view definitions.

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

Oracle views can by queried.

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

Oracle allows the ORDER BY clause in view definitions.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The default extension for an Oracle SQL*Plus file is:

.sql

.txt

.ora

.pls

TRUE ANSWER : ?
YOUR ANSWER : ?