MANAGING DATABASES WITH ORACLE QUIZ

Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Oracle allows the ORDER BY clause in view definitions.

True

False

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

Which of the following is not true of SQL views?

Oracle views can by queried.

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

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

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

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Consistent backup

Differential backup

Inconsistent backup

Full backup

TRUE ANSWER : ?
YOUR ANSWER : ?

When you type Start FILENAME, the statement in your file will be executed automatically.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OnLine ReDo file

Offline ReDo file

Datafile

Control file

TRUE ANSWER : ?
YOUR ANSWER : ?

Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

LIST

CONTENTS

BUFFER

CURRENT

TRUE ANSWER : ?
YOUR ANSWER : ?

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

are case sensitive.

are case insensitive.

must always be in upper case.

must always be in lower case.

TRUE ANSWER : ?
YOUR ANSWER : ?