Database Reference
In-Depth Information
Review Questions
1.
What are the different archiving modes available in the Oracle Database? (Choose all
that apply.)
A.
LOGGING mode
B.
NOLOGGING mode
C.
ARCHIVELOG mode
D.
ARCHIVING mode
E.
NOLOGFILE mode
F.
NOARCHIVELOG mode
G.
RECOVERY mode
2.
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users
complain that they don't want you to shut down the database to perform the backup.
What options are available to you?
A.
Put the database in hot backup mode and perform an online backup, including
backing up the archived redo logs.
B.
Just back up the database data files without shutting down the database.
C.
You will have to wait until you can shut down the database to perform the backup.
D.
Mark each data file as backup in progress, back them up individually, and then
mark them as backup not in progress. No archived redo logs will need to be
backed up.
E.
Back up only the data files that the user will not be touching. Once the user has
finished what they were doing, you can shut down the database and back up the
data files the user changed during the course of the remaining backup.
3.
Your database backup scripts keep failing on the
ALTER TABLESPACE BEGIN BACKUP
command. Your junior DBA informs you that the failure is because the database is in
ARCHIVELOG mode. Is he correct?
A.
Yes
B.
No
C.
There is insufficient information to decide the answer to this question.
4.
What parameter is used to tune instance recovery in Oracle Database 12
c?
A.
INSTANCE_RECOVERY_TIME
B.
FAST_START_RECOVERY_TIME
C.
FAST_MTTR_RECOVERY
D.
FAST_START_MTTR_RECOVERY
E.
None of the above
Search WWH ::
Custom Search