CONCRETE TECHNOLOGY AND DESIGN OF CONCRETE STRUCTURES QUIZ

Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.

False

True

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

Full backup

Inconsistent backup

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

Oracle does NOT support a CASCADE UPDATE constraint.

False

True

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

Which prefixes are available to Oracle triggers?

:old only

Both :new and :old

Neither :new nor :old

:new only

TRUE ANSWER : ?
YOUR ANSWER : ?

You can check on the status of tables with the DESCRIBE or DESC command.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

DURING

INSTEAD OF

AFTER

BEFORE

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not true of SQL views?

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

Oracle views can by queried.

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

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

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL*Plus is a text editor.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑