Exercise: Managing Databases With Oracle

Questions for: Managing Databases With Oracle

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: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz