Managing Databases With Oracle - Study Mode

[#1] Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Correct Answer

(A) Using the Oracle Database Configuration Assistant.

[#2] What Oracle backup and recover file contains user and system data?
Correct Answer

(B) Datafile

[#3] When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
Correct Answer

(A) are case insensitive.

[#4] Which SQL phrase is not supported by Oracle?
Correct Answer

(B) ON UPDATE CASCADE

[#5] What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
Correct Answer

(B) Consistent backup