You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands： CONFIGURE DEFAULT DEVICE TYPE TO sbt； CONFIGURE BACKUP OPTIMIZATION ON； CONFIGURE RETENTION POLICY TO REDUNDANCY 3； From Monday to Saturday， you performed the following actions： Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed？（）A、 The backup will not be performed at all.B、 three timesC、 four timesD、 six times
You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands： CONFIGURE DEFAULT DEVICE TYPE TO sbt； CONFIGURE BACKUP OPTIMIZATION ON； CONFIGURE RETENTION POLICY TO REDUNDANCY 3； From Monday to Saturday， you performed the following actions： Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed？（）
- A、 The backup will not be performed at all.
- B、 three times
- C、 four times
- D、 six times
相关考题：
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:CONFIGURE RETENTION POLICY TO REDUNDANCY 3;Which statement is true?（）A. The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabledB. Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upC. Backup optimization is permanently disabledD. Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
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.)A. The backup piece size will be limited to 300 MBB. The RMAN uses multiplexing to perform backupC. The operation is accomplished using the default channel availableD. The RMAN parallelizes the backup although the parallelism is not set for a channel
You issued the following commands to configure setting in RMAN;RMAN CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN CONFIGURE DEFAULT DEVICE TYPE TO sbt;RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;Then you issued the following command to take the backup:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?（）A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?（）A、CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA B、CONFIGURE DEFAULT DEVICE TYPE TO TAPE C、CONFIGURE DEFAULT DEVICE TYPE TO SBT D、CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE
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？ （）A、a tablespace is taken offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database
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？（）A、configure a default device for RMAN backupsB、temporarily disable the retention policy for RMAN backupsC、configure automatic channel allocation for RMAN backupsD、use the CONFIGURE command to reconfigure the recovery window to 60 days
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
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.)A、The backup piece size will be limited to 300 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?（）A、The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabledB、Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upC、Backup optimization is permanently disabledD、Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）A、configure the database to run in ARCHIVELOG modeB、configure the Flash Recovery Area to enable automatic database backupC、schedule the database backup using DBMS_JOB package after creating the databaseD、schedule the database backup using Recovery Manager （RMAN）commands after creating the databaseE、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database
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？（） A、 MAXSETSIZE TO 2B、 DEVICE TYPE DISK PARALLELISM 2C、 RETENTION POLICY TO REDUNDANCY 2D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
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.（）A、The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.B、The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.C、The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.D、The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
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？ （）A、 A tablespace is taken offline.B、 The database instance is restarted.C、 A new data file is added to an existing tablespace.D、 A successful backup is recorded in the RMAN repository.E、 The RMAN connection is disconnected from the target database.
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?（）A、Only one channel is allocated and the backup is created in the flash recovery areaB、Only one channel is allocated and the backup is created in the destination specified for channel 1C、Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2D、Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
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： RMANBACKUP SECTION SIZE 300M TABLESPACE users； What configuration should be effected to accomplish faster and optimized backups by using the above command？（）A、 The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1B、 The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0C、 The SBT channel must be configured， with the parallelism setting for the SBT device set to 3D、 The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB
You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）A、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；B、 CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；C、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；D、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）A、The database will open, and the tablespace automatically comes out of the backup modeB、The database will be mounted, and recovery must be performed on the USERS tablespace.C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
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？（）A、 configure a default device for RMAN backupsB、 temporarily disable the retention policy for RMAN backupsC、 configure automatic channel allocation for RMAN backupsD、 use the CONFIGURE command to reconfigure the recovery window to 60 days
单选题You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）A CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；B CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；C CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；D CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；
单选题You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands： CONFIGURE DEFAULT DEVICE TYPE TO sbt； CONFIGURE BACKUP OPTIMIZATION ON； CONFIGURE RETENTION POLICY TO REDUNDANCY 3； From Monday to Saturday， you performed the following actions： Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed？（）A The backup will not be performed at all.B three timesC four timesD six times
单选题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？（）Aconfigure a default device for RMAN backupsBtemporarily disable the retention policy for RMAN backupsCconfigure automatic channel allocation for RMAN backupsDuse the CONFIGURE command to reconfigure the recovery window to 60 days
单选题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： RMANBACKUP SECTION SIZE 300M TABLESPACE users； What configuration should be effected to accomplish faster and optimized backups by using the above command？（）A The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1B The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0C The SBT channel must be configured， with the parallelism setting for the SBT device set to 3D The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB
单选题You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?（）AThe command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabledBBackup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upCBackup optimization is permanently disabledDBackup optimization is temporarily disabled because a redundancy-based retention policy is specified
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile
单选题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.（）AThe SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.BThe SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.CThe COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.DThe SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
单选题You have configured the following： RMAN CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’； new RMAN configuration parameters： CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’； new RMAN configuration parameters are successfully stored RMAN SHOW DEVICE TYPE； RMAN configuration parameters are： CONFIGURE DEVICE TYPE SBT PARALLELISM 1； # CONFIGURE DEVICE TYPE DISK PARALLELISM 1； # RMAN CONFIGURE DEVICE TYPE SET PARALLELISM 5； RMAN SHOW DEVICE TYPE； RMAN configuration parameters are： CONFIGURE DEVICE TYPE SBT PARALLELISM 5； CONFIGURE DEVICE TYPE DISK PARALLELISM 1； # How many channels are allocated to SBT？（）A0， because channels have not been defined.B3， as indicated by the degree of parallelism.C1， the default value when device is configured.D5， as indicated by the last parallelism command.
单选题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？（）A MAXSETSIZE TO 2B DEVICE TYPE DISK PARALLELISM 2C RETENTION POLICY TO REDUNDANCY 2D DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2