单选题You issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B When a structural change is made to the database, then a backup of the current control file is performed.C When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D When a structural change is made to the database, then a backup of the alert log file will be performed.

单选题
You issued the following RMAN command:  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()
A

 When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.

B

 When a structural change is made to the database, then a backup of the current control file is performed.

C

 When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.

D

 When a structural change is made to the database, then a backup of the alert log file will be performed.


参考解析

解析: 暂无解析

相关考题:

You issued the following commands to configure setting in RMAN;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

Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?()A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?()A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

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

In which scenario, will you issue the following command?() RMAN REPORT NEED BACKUP DAYS 7;A、 to configure RMAN to maintain backup information in the RMAN repository for seven daysB、 to configure RMAN to maintain backup information in the control file for at least seven daysC、 to display the list of files that have not been backed up for the last seven daysD、 to display the list of files that must be backed up within seven 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

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? ()A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

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?()A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.B、 The backup piece size will be limited to 300 MB.C、 The operation is accomplished using the default channel available.D、 Three channels for the tape drive must be configured by setting the parallelism to three.

You issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A、 When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B、 When a structural change is made to the database, then a backup of the current control file is performed.C、 When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D、 When a structural change is made to the database, then a backup of the alert log file will be performed.

You issue the following command:   RMANCONFIGURE BACKUP OPTIMIZATION ON;   What is the result of this command on your backups?()A、 An incremental backup strategy will be used automatically.B、 Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.C、 RMAN will configure itself for maximum performance at the cost of CPU.D、 RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.E、 RMAN will automatically compress backups.

单选题In which scenario, will you issue the following command?() RMAN REPORT NEED BACKUP DAYS 7;A to configure RMAN to maintain backup information in the RMAN repository for seven daysB to configure RMAN to maintain backup information in the control file for at least seven daysC to display the list of files that have not been backed up for the last seven daysD to display the list of files that must be backed up within seven days

单选题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

单选题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 RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B When a structural change is made to the database, then a backup of the current control file is performed.C When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D When a structural change is made to the database, then a backup of the alert log file will be performed.

单选题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?()AOnly one channel is allocated and the backup is created in the flash recovery areaBOnly one channel is allocated and the backup is created in the destination specified for channel 1CTwo channels are allocated and backup sets are created in the destinations specified for channels 1 and 2DThree channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

多选题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?()AThe RMAN parallelizes the backup although the parallelism is not set for a channel.BThe backup piece size will be limited to 300 MB.CThe operation is accomplished using the default channel available.DThree channels for the tape drive must be configured by setting the parallelism to three.

多选题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.)AThe backup piece size will be limited to 300 MBBThe RMAN uses multiplexing to perform backupCThe operation is accomplished using the default channel availableDThe RMAN parallelizes the backup although the parallelism is not set for a channel

单选题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 issue the following command:   RMANCONFIGURE BACKUP OPTIMIZATION ON;   What is the result of this command on your backups?()A An incremental backup strategy will be used automatically.B Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.C RMAN will configure itself for maximum performance at the cost of CPU.D RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.E RMAN will automatically compress backups.

单选题You issued the following commands to configure setting in RMAN; 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

多选题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? ()Aa tablespace is taken offlineBthe database instance is restartedCa new data file is added to an existing tablespaceDa successful backup is recorded in the RMAN repositoryEthe RMAN connection is disconnected from the target database

单选题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?()AThe backup will terminate because the FORMAT clause was not configured for the channelBIt backs up two copies of data files to tape and disk, and two copies of archived log file on tapeCIt backs up the data files and archived log files to disk, making two copies of each data file and archived log fileDIt backs up the data files and archived log files to tape, making two copies of each data file and archived log file

单选题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

多选题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? ()Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block

多选题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 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.