General Questions

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.
Answer : Option A

Question 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
Answer : Option B

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.
Answer : Option A

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]
Answer : Option B

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
Answer : Option B