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.
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
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.
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]
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