Database Reference
In-Depth Information
13.
Which of the following are valid
UNTIL
command options when attempting point-in-
time recovery in RMAN? (Choose all that apply.)
A.
UNTIL TIME
B.
UNTIL CHANGE
C.
UNTIL SEQUENCE
D.
UNTIL SCN
E.
UNTIL COMMIT
14.
Which of the following does the
RECOVER
command not do?
A.
Restore archived redo logs
B.
Apply archived redo logs
C.
Restore incremental backups
D.
Apply incremental backups
E.
Restore data file images
15.
You have a database with the following tablespaces:
SYSTEM
,
SYSAUX
,
UNDO
,
USERS
,
TEMP
.
You want to roll back the data in the
USERS
tablespace to the way it looked yesterday.
Which tablespaces do you need to perform a point-in-time restore operation on in order
to complete this task? (Choose all that apply.)
A.
SYSTEM
B.
SYSAUX
C.
UNDO
D.
USERS
E.
TEMP
F.
This restore is not possible.
16.
You have backed up your database using image copies. You have lost the
SYSTEM
tablespace and need to restart your database as quickly as possible. What is the cor-
rect solution?
A.
Restore the
SYSTEM
tablespace from the last backup set and then recover the database.
B.
Restore the
SYSTEM
tablespace image copy using the
RESTORE
command and then
restore the database.
C.
Use the
SWITCH DATAFILE
command to instantly switch to the data file copy,
recover the tablespace, and open the database.
D.
The database is not recoverable in this situation with image copies.
E.
Manually copy the data file image copy to the correct location and then manually
restore the database from SQL*Plus.
Search WWH ::
Custom Search