MANAGING DATABASES WITH ORACLE QUIZ

When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

must always be in lower case.

must always be in upper case.

are case sensitive.

are case insensitive.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ALTER TABLE [TableName].

CHANGE TABLE [TableName].

UPDATE TABLE [TableName].

MODIFY TABLE [TableName].

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 commands, column names, table names, view names and all other database elements are case sensitive.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

What Oracle backup and recover file contains user and system data?

Control file

Datafile

Offline ReDo file

OnLine ReDo file

TRUE ANSWER : ?
YOUR ANSWER : ?

Oracle allows the ORDER BY clause in view definitions.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Oracle does NOT support a CASCADE UPDATE constraint.

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]

Show [FileName]

Edit [FileName]

Open [FileName]

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Of the three ways to create an Oracle database, which one is the easiest and most recommended?

Using the Oracle Database Configuration Assistant.

Using the Oracle-supplied database creation procedures.

None of these

Using the SQL CREATE DATABASE command.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑