Database - Managing Databases with Oracle

Exercise :: Managing Databases with Oracle - General Questions

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

Explanation:

No answer description available for this question. Let us discuss.

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

Explanation:

No answer description available for this question. Let us discuss.

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

Explanation:

No answer description available for this question. Let us discuss.

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

Explanation:

No answer description available for this question. Let us discuss.

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

Explanation:

No answer description available for this question. Let us discuss.