called RCAT_OWN. Assume the environment is configured for the ORCL database. (Choose all that apply.)
A. rman target=/ catalog=/@rcat
B. rman target=/ catalog=rcat_own/rcat_own C. rman target=/ catalog=rcat_own/rcat_own@RCAT
D. rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT
E. You cannot connect to the target database and the recovery catalog at the same time.
Answer: CD Section: (none)
QUESTION 413
What command would you issue to enable automated backups of control files?
A. alter database controlfile autobackup on B. alter system controlfile autobackup on C. configure controlfile autobackup on D. enable controlfile autobackup
Answer: C Section: (none)
QUESTION 414
Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.
A. restore database; B. recover database; C. shutdown immediate D. startup
E. restore archivelog all; F. alter database open G. a, b, c, d, e, f H. c, b, a, d, e, f I. c, b, a, d, f J. c, a, b, d K. c, a, e, b, d, f
Answer: E Section: (none)
QUESTION 415
Which commands are used for RMAN database recovery? (Choose all that apply.)
A. restore B. repair C. copy D. recover E. replace
Answer: AD Section: (none)
Explanation/Reference:
QUESTION 416
Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?
A. restore controlfile B. restore database C. restore spfile D. recover database E. alter database open
F. alter database open resetlogs G. b, a, c, d, e H. a, c, b, d, f I. c, a, b, d, e J. c, a, b, d, f K. e, a, b, d, c
Answer: D Section: (none)
QUESTION 417
If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?
A. Complete database recovery. B. Incomplete database recovery. C. Approximate database recovery. D. Archived database recovery.
E. The database could not be recovered with RMAN.
Answer: B Section: (none)
QUESTION 418
Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?
A. restore datafiles until time '09/28/2008:21:03:11'; B. restore database files until time '09/28/2008:18:00:00'; C. restore database until time '09/28/2008:18:00:00'; D. recover database until time '09/28/2008:18:00:00'; E. recover database until timestamp '09/28/2008:18:00:00';
Answer: C Section: (none)
Explanation/Reference:
QUESTION 419
What is the end result of these commands if they are successful?
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name
ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default Backup database tag=gold_copy plus archivelog tag=gold_copy delete input; Backup database tag=silver_copy plus archivelog tag=silver_copy delete input;
A. Attempting to restore silver_copy will fail. B. Attempting to restore gold_copy will fail.
C. Both backups will be available for restore without question.
D. Attempting to restore gold_copy may or may not succeed. E. You will not be able to restore either gold_copy or silver_copy.
Answer: D Section: (none)
QUESTION 420
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?
A. Database Datafiles B. Database Control Files C. Online redo logs D. Archived redo logs E. The database SPFILE
F. None of the above, all these files are backed up.
Answer: C Section: (none)
QUESTION 421
True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace. A. True B. False
Answer: B Section: (none)
QUESTION 422
You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?
A. restore controlfile until time
`09/30/2008:18:00:00'; B. restore database until time
`09/30/2008:18:00:00'; C. restore spfile until time
`09/30/2008:18:00:00';; D. recover database until time
`09/30/2008:18:00:00'; E. alter database open resetlogs; F. alter database open; G. b, d, e H. b, d, f I. c, a, b, d, e J. c, a, b, d, f K. a, b, d, e
Answer: A Section: (none)
Explanation/Reference:
QUESTION 423
What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?
A. sql 'alter database datafile 4 online'; B. restore datafile 4; C. recover datafile 4;
D. sql 'alter database datafile 4 offline'; E. startup F. shutdown G. a, c, b, d H. d, b, c, a I. f, d, b, c, a, e J. c, a, b, d, f K. a, b, d, e
Answer: B Section: (none)
QUESTION 424