ALLIGATION OR MIXTURE PROBLEMS QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The default extension for SQL*Plus is .sql.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which prefixes are available to Oracle triggers?

:old only

:new only

Neither :new nor :old

Both :new and :old

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 semicolon ( ; ) followed by [Enter].

A colon ( : ) followed by [Enter].

A period ( . ) followed by [Enter].

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not true of SQL views?

Oracle views can by queried.

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.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

MODIFY TABLE [TableName].

UPDATE TABLE [TableName].

CHANGE TABLE [TableName].

ALTER TABLE [TableName].

TRUE ANSWER : ?
YOUR ANSWER : ?

Sequences guarantee valid surrogate key values.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Offline ReDo file

Control file

Datafile

OnLine ReDo file

TRUE ANSWER : ?
YOUR ANSWER : ?