E. Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first.
Answer: C Section: (none)
QUESTION 449
What is the result of this command? RMAN> Report need backup days 3;
A. Lists all datafiles created in the last three days that are not backed up. B. Lists all datafiles not recoverable based on the current retention criteria.
C. Lists all datafiles not backed up in the last three days. The datafile is not recoverable. D. Lists all datafiles that need to be backed up due to unrecoverable operations.
E. Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.
Answer: E Section: (none)
QUESTION 450
Why would you execute the report obsolete command?
A. To list all backups that were no longer available for restore operations B. To list all backups that had aged beyond the RMAN retention criteria
C. To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the
backup media
D. To list all datafiles that are no longer part of the database and thus do not need to be backed up E. To list all archived redo logs that are no longer needed for any database recovery
Answer: B Section: (none)
Explanation/Reference:
QUESTION 451
What information does the report schema command not provide? (Choose all that apply.)
A. Size of the datafiles B. Size of the tempfiles
C. Date of last backup for datafiles and tempfiles D. Filenames for each datafile
E. Checkpoint SCN associated with the last RMAN backup
Answer: CE Section: (none)
QUESTION 452
If a backup is expired, which of the following is true?
A. It can never be used for a restore/recover operation.
B. Oracle will remove the backup set pieces from the flash recovery area. C. The backup has been used at least once to restore and recover the database. D. The backup is no longer valid because of a resetlogs operation. E. The physical backup set pieces are missing from the media.
Answer: E Section: (none)
QUESTION 453
True or false: tablespace point-in-time recovery is possible only with RMAN. A. True B. False
Answer: B Section: (none)
QUESTION 454
Which command is used to begin a tablespace point-in-time recovery?
A. Restore tablespace B. Recover tablespace C. Tablespace recover D. Recover to time E. recover datafile
Answer: B Section: (none)
QUESTION 455
When youre performing active database duplication, a backup of what kind is required?
A. A current RMAN backup-set backup is required. B. No backup is required.
C. An RMAN image backup is required. D. A manual backup is required.
E. A \
Answer: B Section: (none)
Explanation/Reference:
QUESTION 456
Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?
A. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 create duplicate target database
to neworcl from active database nofilenamecheck spfile set control_files ' c:\\oracle\\oradata\\neworcl\\control01.ctl',
'c:\\oracle\\oradata\\neworcl\\control02.ctl' set db_file_name_convert 'c:\\oracle\\oradata\\orcl','
c:\\oracle\\oradata\\neworcl' set log_file_name_convert 'c:\\oracle\\oradata\\orcl','c:\\oracle\\oradata\\neworcl'; B. Set oracle_sid=orcl
rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database nofilenamecheck spfile set control_files
'c:\\oracle\\oradata\\neworcl\\control01.ctl', 'c:\\oracle\\oradata\\neworcl\\control02.ctl' set db_file_name_convert 'c:\\oracle\\oradata\\orcl','c:\\oracle\\oradata\\neworcl' set log_file_name_convert 'c:\\oracle\\oradata\\orcl','c:\\oracle\\oradata\\neworcl';
C. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database to
neworcl nofilenamecheck spfile set control_files 'c:\\oracle\\oradata\\neworcl\\control01.ctl', 'c:\\oracle\\oradata\\neworcl\\control02.ctl' set db_file_name_convert 'c:\\oracle\\oradata\\orcl','
c:\\oracle\\oradata\\neworcl' set log_file_name_convert 'c:\\oracle\\oradata\\orcl','c:\\oracle\\oradata\\neworcl'; D. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert duplicate target database to neworcl
from active database nofilenamecheck spfile set control_files 'c:\\oracle\\oradata\\neworcl\\control01.ctl', 'c:\\oracle\\oradata\\neworcl\\control02.ctl' set db_file_name_convert 'c:\\oracle\\oradata\\orcl','
c:\\oracle\\oradata\\neworcl' set log_file_name_convert 'c:\\oracle\\oradata\\orcl','c:\\oracle\\oradata\\neworcl'; E. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database to
'c:\\oracle\\oradata\\neworcl\\control02.ctl' set db_file_name_convert 'c:\\oracle\\oradata\\orcl','
c:\\oracle\\oradata\\neworcl' set log_file_name_convert 'c:\\oracle\\oradata\\orcl','c:\\oracle\\oradata\\neworcl';
Answer: E Section: (none)
QUESTION 457
How many database instances are used during a database-duplication process? A. One B. Two C. Three D. Four E. Five
Answer: B Section: (none)
QUESTION 458
What command is used to reset a database to a previous incarnation?
A. reset incarnation B. incarnation reset
C. reset database to incarnation D. reset database incarnation E. reset databse incarnation number
Answer: C Section: (none)
Explanation/Reference:
QUESTION 459
What view would you use to determine if a given tablespace is fully self-contained for the
neworcl from active database nofilenamecheck spfile set control_files 'c:\\oracle\\oradata\\neworcl\\control01.ctl',
execution of a tablespace point-in-time recovery?
A. TS_CHECK B. TPITR_CHECK C. TS_PITR_CHECK D. CHECK_TSPITR E. PITR_TS_CHECK
Answer: C Section: (none)
QUESTION 460
When performing a full database disaster recovery with RMAN, in what order would you execute these steps?
A. Restore the control file from autobackups. B. Run the RMAN restore and recover command. C. Restore the database spfile from autobackups. D. Make the RMAN backup set pieces available.
E. Open the database with the alter database open resetlogs command. F. Open the database with the alter database open command. G. a, b, c, d, e, f H. c, d, a, b, f I. d, c, a, b, f J. d, b, d, c, e K. d, c, a, b, e
Answer: E Section: (none)
QUESTION 461
When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?
A. log_file_name_convert B. convert_log_file_name C. file_name_convert_log D. redo_log_file_name_convert