You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting?()
第1题:
You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly. On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting?()
第2题:
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)
第3题:
You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command: RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; When a backup is performed, what would be the status of this backup after seven days?()
第4题:
You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?()
第5题:
You have issued the following command: RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 100 DAYS; What will be the result of using the above command?()
第6题:
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()
第7题:
You performed a backup of the flash recovery area by using the following command for the first time: RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()
第8题:
to configure RMAN to maintain backup information in the RMAN repository for seven days
to configure RMAN to maintain backup information in the control file for at least seven days
to display the list of files that have not been backed up for the last seven days
to display the list of files that must be backed up within seven days
第9题:
A tablespace is taken offline.
The database instance is restarted.
A new data file is added to an existing tablespace.
A successful backup is recorded in the RMAN repository.
The RMAN connection is disconnected from the target database.
第10题:
backups that can be deleted
stored scripts in the recovery catalog
backup sets and image copies that are obsolete
only the most recent backup sets or image copies
backups that do not have the AVAILABLE status in RMAN repository
第11题:
The backup status will be marked expired in RMAN recovery catalog.
The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery catalogl
The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).
The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).
第12题:
The backup would be marked as invalid.
The backup would be marked as obsolete.
The backup would be removed from the media.
The backup would be removed from the RMAN repository.
第13题:
In which scenario, will you issue the following command?() RMAN> REPORT NEED BACKUP DAYS 7;
第14题:
Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?()
第15题:
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()
第16题:
In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()
第17题:
In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager (RMAN)?()
第18题:
Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed? ()
第19题:
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage?()
第20题:
The backup would be retained on the media for 31 days.
The backup would be maintained in the recovery catalog for 31 days.
The backup metadata would be retained in the control file for 31 days.
The backup metadata would be maintained in the recovery catalog for 31 days.
Automatic backups of the control file will be retained in the flash recovery area for 31 days.
第21题:
configure a default device for RMAN backups
temporarily disable the retention policy for RMAN backups
configure automatic channel allocation for RMAN backups
use the CONFIGURE command to reconfigure the recovery window to 60 days
第22题:
a tablespace is taken offline
the database instance is restarted
a new data file is added to an existing tablespace
a successful backup is recorded in the RMAN repository
the RMAN connection is disconnected from the target database
第23题:
The retention policy is cleared.
RMAN does not consider any backup as obsolete.
The retention policy is set to its default setting of redundancy 1.
The retention policy is set to its default setting of recovery window 7.