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

A. Using the Oracle Database Configuration Assistant.
B. Using the Oracle-supplied database creation procedures.
C. Using the SQL CREATE DATABASE command.
D. None of the above is correct.

Show Answer

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

A. Control file
B. Datafile
C. OnLine ReDo file
D. Offline ReDo file

Show Answer

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

A. are case insensitive.
B. are case sensitive.
C. must always be in lower case.
D. must always be in upper case.

Show Answer

14. Which SQL phrase is not supported by Oracle?

A. ON DELETE CASCADE
B. ON UPDATE CASCADE
C. CREATE SEQUENCE [SequenceName] D. DROP SEQUENCE [SequenceName] Show Answer

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

A. Full backup
B. Consistent backup
C. Inconsistent backup
D. Differential backup

Show Answer