Question 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.
Question 12 :
What Oracle backup and recover file contains user and system data?
A). Control file
C). OnLine ReDo file
D). Offline ReDo file
Question 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.
Question 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]
Question 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