4
8
7
0
第1题:
Which command is used to configure RMAN to perform a compressed backup for every backup executed?()
第2题:
Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?()
第3题:
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? ()
第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题:
View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4; } What is the multiplexing level in the preceding backup process?()
第6题:
You execute the following command to perform a backup by using Recovery Manager (RMAN): RMAN> run {allocate channel c1 type sbt; backup datafile 1; } The command errors out. A part of the error message is as follows: RMAN/x7f03009: failure of allocate command on c1 channel ORA/x7f19554: error allocating device, device type: SBT_TAPE, device name: What could explain why the statement failed?()
第7题:
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?()
第8题:
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.
第9题:
Because the progress is reported for each data file
Because the progress is reported for each backup set
Because other RMAN sessions have issued the same BACKUP command
Because new data files have been added to the database while the RMAN backup is in progress
第10题:
4
8
7
0
第11题:
BACKUP AS COMPRESSED BACKUPSET DATABASE
BACKUP AS COMPRESSED COPY OF DATABASE
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
BACKUP DATABASE COMPRESS
第12题:
The backup will terminate because the FORMAT clause was not configured for the channel
It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第13题:
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.)
第14题:
You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?()
第15题:
Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’;To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()
第16题:
View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN> BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?()
第17题:
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN> RUN 2> { 3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4> BACKUP DATABASE; 5> } Which statement is true about the outcome?()
第18题:
Examine this statement: RMAN >BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2; What state must the target database be in for you to use this RMAN command?()
第19题:
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
第20题:
The data file is checked for physical corruption and backed up if found clean.
The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
第21题:
Only one channel is allocated and the backup is created in the flash recovery area
Only one channel is allocated and the backup is created in the destination specified for channel 1
Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
第22题:
sbt is not a valid device type.
Media Management Library was not loaded.
The sbt device cannot be used for data file backups.
No path was defined in the ALLOCATE CHANNEL command.
The channel is currently being used by another RMAN session.
第23题:
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
第24题:
MAXSETSIZE TO 2
DEVICE TYPE DISK PARALLELISM 2
RETENTION POLICY TO REDUNDANCY 2
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2