考题
You observed the following output for a user session:What do you infer from the preceding output?()
A. Resumable set for session with sid 18B. The user session has entered into a deadlockC. The database instance is enabled to use asynchronous commitD. The threshold warning limit is exceeded for the tablespace that is used by the user session
考题
Observe the following warning in an RMAN session of your database instance:WARNING: new failures were found since last LIST FAILURE commandWhich statement describes the scenario that must have produced this warning?()A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURED. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
考题
View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.What is the reason for this error?()
A. Another repair session is running concurrently.B. The failure ID has not been mentioned in the command for data file 5.C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE 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).
考题
Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?()A. It contains data till the last backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database
考题
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?()A、The instance would hang.B、The instance needs to be shut down.C、The instance would be in the open state.D、The instance would abort in such cases.E、The instance would be in the open and invalid state.F、The instance would in the open state, but all the background processes will be restarted.
考题
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
考题
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 executed the following commands in an RMAN session for your database instance that has failures: RMAN LIST FAILURE; After some time, you executed the following command in the same session: RMAN ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution ofthe last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario()A、It produces a warning for new failures before advising for CRITICAL and HIGH failures.B、It ignores new failures and considers the failures listed in the last LIST FAILURE command only.C、It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignoredD、It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
考题
Which statement describes the significance of the CHANGE FAILURE command in RMAN?()A、 It is used to change failure priority only for HIGH or LOW priorities.B、 It is used to execute the advised repair script.C、 It is used to change failure priority only for the CRITICAL priority.D、 It is used to explicitly close the open failures.E、 It is used to inform the database about the repair after the repair script executes.
考题
Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: RMAN RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; } Which statement is true about the duplicate database in this scenario?() A、 It contains data till the last backupB、 It contains all data from target database until the current timeC、 It contains all data from only the committed transactions in the target databaseD、 It contains all data except that which is used by the transactions in the current online redo file of target database
考题
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 issue the following command on the RMAN prompt. RMAN REPORT NEED BACKUP DAYS = 5 DATABASE; Which statement is true about executing this command?()A、 It will display a list of files that need incremental backup.B、 It will display a list of files that need backup after five days.C、 It will display a list of files that were backed up in the last five days.D、 It will display a list of files that have not been backed up in the last five days.E、 It will apply the current retention policy to determine the files that need to be backed up.
考题
Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?()A、The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)B、The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)C、The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURED、The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
考题
Observe the following warning in an RMAN session of your database instance: WARNING:// new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?()A、 The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)B、 The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)C、 The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURED、 The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
考题
You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?() A、 It will display a list of files that need incremental backupB、 It will display a list of files that need backup after five daysC、 It will display a list of files that were backed up in the last five daysD、 It will display a list of files that have not been backed up in the last five daysE、 It will apply the current retention policy to determine the files that need to be backed up
考题
单选题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
考题
单选题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 are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use?()A
LIST commandB
CROSSCHECK commandC
REPORT commandD
SHOW command
考题
单选题You executed the following commands in an RMAN session for your database instance that has failures: RMAN LIST FAILURE; After some time, you executed the following command in the same session: RMAN ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?()A
It produces a warning for new failures before advising for CRITICAL and HIGH failures.B
It ignores new failures and considers the failures listed in the last LIST FAILURE command only.C
It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.D
It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
考题
单选题Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: RMAN RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; } Which statement is true about the duplicate database in this scenario?()A
It contains data till the last backupB
It contains all data from target database until the current timeC
It contains all data from only the committed transactions in the target databaseD
It contains all data except that which is used by the transactions in the current online redo file of target database
考题
单选题Observe the following warning in an RMAN session of your database instance: WARNING:// new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?()A
The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)B
The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)C
The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURED
The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
考题
单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()A
It will display a list of files that need incremental backupB
It will display a list of files that need backup after five daysC
It will display a list of files that were backed up in the last five daysD
It will display a list of files that have not been backed up in the last five daysE
It will apply the current retention policy to determine the files that need to be backed up
考题
单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()A
It will display a list of files that need incremental backupB
It will display a list of files that need backup after five daysC
It will display a list of files that were backed up in the last five daysD
It will display a list of files that have not been backed up in the last five daysE
It will apply the current retention policy to determine the files that need to be backed up
考题
多选题Which statement describes the significance of the CHANGE FAILURE command in RMAN?()AIt is used to change failure priority only for HIGH or LOW priorities.BIt is used to execute the advised repair script.CIt is used to change failure priority only for the CRITICAL priority.DIt is used to explicitly close the open failures.EIt is used to inform the database about the repair after the repair script executes.
考题
单选题You issue the following command on the RMAN prompt. RMAN REPORT NEED BACKUP DAYS = 5 DATABASE; Which statement is true about executing this command?()A
It will display a list of files that need incremental backup.B
It will display a list of files that need backup after five days.C
It will display a list of files that were backed up in the last five days.D
It will display a list of files that have not been backed up in the last five days.E
It will apply the current retention policy to determine the files that need to be backed up.
考题
单选题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