网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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 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 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 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
考题
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 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 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 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;
考题
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 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 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
考题
单选题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 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
考题
单选题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?()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
考题
多选题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.()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
考题
单选题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?()A
0, because channels have not been defined.B
3, as indicated by the degree of parallelism.C
1, the default value when device is configured.D
5, as indicated by the last parallelism command.
考题
单选题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 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
考题
单选题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
热门标签
最新试卷