MANAGING DATABASES WITH ORACLE QUIZ

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

Application failure

Media Failure

Instance Failure

Rollback failure

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

Which of the following is NOT an Oracle-supported trigger?

DURING

AFTER

BEFORE

INSTEAD OF

TRUE ANSWER : ?
YOUR ANSWER : ?

After a table has been created, its structure can be modified using the SQL command:

UPDATE TABLE [TableName].

ALTER TABLE [TableName].

CHANGE TABLE [TableName].

MODIFY TABLE [TableName].

TRUE ANSWER : ?
YOUR ANSWER : ?

Sequences guarantee valid surrogate key values.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Oracle allows the ORDER BY clause in view definitions.

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

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

False

True

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

Which of the following is not true about modifying table columns?

You can drop a column at any time.

You can increase the number of characters in character columns or the number of digits in numeric columns

You cannot increase or decrease the number of decimal places.

You can add a column at any time as long as it is a NULL column.

TRUE ANSWER : ?
YOUR ANSWER : ?