121、

121.Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)A. It creates jobs without considering the priorities associated with them.B. It translates tasks into jobs for execution by the scheduler.C. It determines the list of jobs that must be created for each maintenance window.D. It is spawned by the MMON background process at the start of the maintenance window.E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

Answer: BCD

 

122、

122.Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)A. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).B. The problem key is the same as the incident number.C. The database sends an incident alert to the Oracle Enterprise Manager Database Home page.D. Every problem has a problem key, which is a text string that describes the problem.E. The database makes an entry into the alert log file when problems and incidents occur.

Answer: CDE

 

123、

123.What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)A. It cannot generate recommendations that support multiple workload queries.B. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.C. It can recommend partitioning only on tables that have at least 10,000 rows.D. It can recommend only B-tree indexes and not bitmap or function-based indexes.

Answer: BC

 

124、

124.You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;Which statement is true in this scenario? A. It starts the ASM fast mirror resync.B. All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.C. It drops all disk paths from the dga disk group.D. All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

Answer: D

 

125、

125.Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)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.

Answer: AD