MANAGING DATABASES WITH ORACLE QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Control file

OnLine ReDo file

Offline ReDo file

Datafile

TRUE ANSWER : ?
YOUR ANSWER : ?

The only time that case matters is inside quotation marks of strings.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

To see the contents of the SQL*Plus buffer, type:

BUFFER

LIST

CURRENT

CONTENTS

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Media Failure

Application failure

Rollback failure

Instance Failure

TRUE ANSWER : ?
YOUR ANSWER : ?

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

CHANGE TABLE [TableName].

MODIFY TABLE [TableName].

ALTER TABLE [TableName].

UPDATE TABLE [TableName].

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

True

False

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

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

Consistent backup

Inconsistent backup

Differential backup

Full backup

TRUE ANSWER : ?
YOUR ANSWER : ?

↑