IndiaBIX

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?
Using the Oracle Database Configuration Assistant.
Using the Oracle-supplied database creation procedures.
Using the SQL CREATE DATABASE command.
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
12.
What Oracle backup and recover file contains user and system data?
Control file
Datafile
OnLine ReDo file
Offline ReDo file
Answer: Option
Explanation:
No answer description is available. Let's discuss.
13.
When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
are case insensitive.
are case sensitive.
must always be in lower case.
must always be in upper case.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
14.
Which SQL phrase is not supported by Oracle?
ON DELETE CASCADE
ON UPDATE CASCADE
CREATE SEQUENCE [SequenceName]
DROP SEQUENCE [SequenceName]
Answer: Option
Explanation:
No answer description is available. Let's discuss.
15.
What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
Full backup
Consistent backup
Inconsistent backup
Differential backup
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers