MAXSETSIZE TO 2
DEVICE TYPE DISK PARALLELISM 2
RETENTION POLICY TO REDUNDANCY 2
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
第1题:
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()
第2题:
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? ()
第3题:
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?()
第4题:
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()
第5题:
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?()
第6题:
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?()
第7题:
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
第8题:
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
第9题:
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
第10题:
The RMAN parallelizes the backup although the parallelism is not set for a channel.
The backup piece size will be limited to 300 MB.
The operation is accomplished using the default channel available.
Three channels for the tape drive must be configured by setting the parallelism to three.
第11题:
Backup compression should be enabled
Parallelism for the channel should be set to 2
All the files must be backed up as backup sets
The backup may be stored either on disk or on media with media manager
第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 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 the RMAN. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true regarding the execution of the above command?()
第15题:
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?()
第16题:
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?()
第17题:
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN>BACKUP SECTION SIZE 300M TABLESPACE users; What configuration should be effected to accomplish faster and optimized backups by using the above command?()
第18题:
A backup of the target database when it is mounted
A backup of online redo log files when the database is open
A backup of only used data blocks in the file beingbeingbackup up
A backup of online, read/write data files when the database is open
A backup of only those data blocks that have changed since a previous backup
A backup of online, read/write data files when the database is in the NOMOUNT state.
第19题:
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
第20题:
The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1
The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0
The SBT channel must be configured, with the parallelism setting for the SBT device set to 3
The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB
第21题:
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).
第22题:
The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
第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