Repair the corrupted blocks. If any. In the backup created
Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
Back up the database after checking whether array of the files have corrupted blocks
Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
第1题:
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?()
第2题:
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()
第3题:
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?()
第4题:
7, 2, 3, 1, 4, 6, 5
7, 1, 3, 2, 6, 5, 4
2, 1, 7, 6, 3, 5, 4
2, 7, 3, 5, 1, 6, 4
第5题:
SYSDBA
SYSOPER
No system privileges are required for the RMAN user.
Only SYS user can connect and execute RMAN commands on a target database.
第6题:
shut down and restart the instance
add new tempfiles to the temporary tablespaces after recovery
perform a media recovery and open the database with the RESETLOGS option
perform a media recovery and bring the database to NOARCHIVELOG mode
第7题:
back up the control file to trace
bring database to the MOUNT state
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
第8题:
Repair the corrupted blocks. If any. In the backup created
Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
Back up the database after checking whether array of the files have corrupted blocks
Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
第9题:
The database is in NOMOUNT state.
The database is in ARCHIVELOG mode and the tablespace is online.
The database is in ARCHIVELOG mode and the tablespace is offline.
The database is in NOARCHIVELOG mode and the tablespace is online.
The database is in NOARCHIVELOG mode and the tablespace is offline.
第10题:
back up the control file to trace
bring database to the MOUNT state
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
第11题:
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
第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题:
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()
第14题:
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()
第15题:
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: % rman target / What would be the effect of this command?()
第16题:
A base catalog exists
The recovery catalog is empty
The base recovery catalog must be dropped
A target database is registered in the recovery catalog
第17题:
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).
第18题:
RMAN would use the current operating system location to place the backup.
RMAN would use the control file of the target database to maintain the backup.
RMAN would use the recovery catalog of the target database to maintain the backup.
RMAN would use the control file of the target database to maintain the backup metadata.
RMAN would use the recovery catalog of the target database to maintain the backup metadata.
第19题:
by using the trace file
by using the alert log file
by using the database ID
by using the server parameter file
by using the V$CONTROLFILE view
by using the autobackup format configuration setting
第20题:
RMAN would use the current operating system location to place the backup.
RMAN would use the control file of the target database to maintain the backup.
RMAN would use the recovery catalog of the target database to maintain the backup.
RMAN would use the control file of the target database to maintain the backup metadata.
RMAN would use the recovery catalog of the target database to maintain the backup metadata.
第21题:
run { open script backup_database; run script backup_database }
run { engage script backup_database; }
run { run script backup_database; }
Run { execute script backup_database; }
The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
第22题:
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
第23题:
when you change the name of a datafile
when you drop a table from the database
when you take an export of the database
when you back up the database using OS utilities
when you issue an ALTER SYSTEM SWITCH LOGFILE statement
when you issue a BACKUP command from inside the RMAN run block
第24题:
target database
auxiliary database
third-party database
recovery catalog database