网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
You executed the following command in the Recovery Manager (RMAN):   RMAN> REPORT NEED BACKUP days 3;   What is the output of this command?()
A

 A list of files that require a backup within 3 days

B

 A list of files requiring more than 3 days of archivelogs to apply

C

 A list of files that RMAN recommends be backed up only once in every three days,based on low volatility

D

 A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them


参考答案

参考解析
解析: 暂无解析
更多 “单选题You executed the following command in the Recovery Manager (RMAN):   RMAN REPORT NEED BACKUP days 3;   What is the output of this command?()A  A list of files that require a backup within 3 daysB  A list of files requiring more than 3 days of archivelogs to applyC  A list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD  A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them” 相关考题
考题 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).

考题 You executed the following command to perform a backup of the USERS tablespace:  SQL ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1:  ORA-01123: cannot start online backup; media recovery not enabled  What could be the reason for this error()A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.

考题 You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:RMAN REPORT NEED BACKUP days 3;What would be the output of this command?()A、 a list of files that require a backup within three daysB、 a list of files that have not been backed up for three daysC、 a list of files that RMAN recommends be backed up only once in every three days, based on low volatilityD、 a list of files for which a backup has already been performed and may need a backup after three days

考题 You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

考题 The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN REPORT OBSOLETE; What would you see in the output?()A、 a list of all those files that have been deleted in the last two daysB、 a list of all those files that have been recovered within the last two daysC、 a list of all the expired backups and copiesD、 a list of backups and copies that are outside the range covered by the current retention policy

考题 You decided to change the location of the flash recovery area. You executed the following command:   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’;   Which statement is true?()A、 The location can be changed only if the flash recovery area is empty.B、 After executing the command, all new flash recovery area files will be created in the new location.C、 The command will generate an error because you cannot change the flash recovery area while the database is open.D、 All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.

考题 You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command:  RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;  When a backup is performed, what would be the status of this backup after seven days?()A、 The backup would be marked as invalid.B、 The backup would be marked as obsolete.C、 The backup would be removed from the media.D、 The backup would be removed from the RMAN repository.

考题 You disabled the Flashback Database feature by using the following command:  SQL ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs?()A、 Flashback logs are not deleted.B、 Flashback logs are deleted automatically.C、 Flashback logs are deleted only if you are using Recovery Manager (RMAN)D、 Flashback logs are deleted only if you are using Oracle Manager Files (OFM)E、 Flashback logs are deleted only if you are using Automatic Storage Management (ASM)

考题 You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database

考题 You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup?()A、by using the trace fileB、by using the alert log fileC、by using the database IDD、by using the server parameter fileE、by using the V$CONTROLFILE viewF、by using the autobackup format configuration setting

考题 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?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、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).

考题 Which statement about using RMAN stored scripts is true?()A、To create and execute an RMAN stored script, you must use a recovery catalog.B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

考题 单选题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?()A The backup status will be marked expired in RMAN recovery catalog.B The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E 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).

考题 多选题In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command:  RMAN RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup?()Ashut down and restart the instanceBadd new tempfiles to the temporary tablespaces after recoveryCperform a media recovery and open the database with the RESETLOGS optionDperform a media recovery and bring the database to NOARCHIVELOG mode

考题 单选题You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()A The location can be changed only if the flash recovery area is empty.B After executing the command, all new flash recovery area files will be created in the new location.C The command will generate an error because you cannot change the flash recovery area while the database is open.D All the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.

考题 单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()A  back up the control file to traceB  bring database to the MOUNT stateC  open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD  set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

考题 单选题You executed the following command in Recovery Manager (RMAN):   RMAN REPORT NEED BACKUP days 3;   What is the output of this command?()A  a list of files that require a backup within three daysB  a list of files requiring more than 3 days of archive logs to applyC  a list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD  a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

考题 多选题You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup?()Aby using the trace fileBby using the alert log fileCby using the database IDDby using the server parameter fileEby using the V$CONTROLFILE viewFby using the autobackup format configuration setting

考题 单选题You decided to change the location of the flash recovery area. You executed the following command:   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’;   Which statement is true?()A  The location can be changed only if the flash recovery area is empty.B  After executing the command, all new flash recovery area files will be created in the new location.C  The command will generate an error because you cannot change the flash recovery area while the database is open.D  All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.

考题 单选题The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN REPORT OBSOLETE; What would you see in the output?()A  a list of all those files that have been deleted in the last two daysB  a list of all those files that have been recovered within the last two daysC  a list of all the expired backups and copiesD  a list of backups and copies that are outside the range covered by the current retention policy

考题 单选题You disabled the Flashback Database feature by using the following command:  SQL ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs?()A  Flashback logs are not deleted.B  Flashback logs are deleted automatically.C  Flashback logs are deleted only if you are using Recovery Manager (RMAN)D  Flashback logs are deleted only if you are using Oracle Manager Files (OFM)E  Flashback logs are deleted only if you are using Automatic Storage Management (ASM)

考题 单选题Which statement about using RMAN stored scripts is true?()A To create and execute an RMAN stored script, you must use a recovery catalog.B When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

考题 多选题You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.

考题 单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

考题 单选题You disabled the Flashback Database feature by using the following command:  SQL ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs?()A Flashback logs are not deleted.B Flashback logs are deleted automatically.C Flashback logs are deleted only if you are using Recovery Manager (RMAN).D Flashback logs are deleted only if you are using Oracle Managed Files (OMF).E Flashback logs are deleted only if you are using Automatic Storage Management (ASM).

考题 单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A  target databaseB  auxiliary databaseC  third-party databaseD  recovery catalog database