053 (25)

121.

121. Which three statements is true regarding the functioning ofThe autotask Background Process (ABP)? (Choose three.) A. It creates jobs without considering the priorities associated withthem. B. It translates Tasks intoJobs forExecution byThe Scheduler. C. It determines the list ofJobs that must be created forEach Maintenance window. D. It isSpawned byThe Mmon background process at the start ofThe Maintenance window. E. It maintains a repositoryinchThe SYSTEM tablespace toStore the history ofThe execution of  AllTasks.

122.

122. Which statements is true regarding the concept ofProblems andIncidentsinchThe Fault diagnosability infrastructure forOracleDatabase11g? (Choose Allthat apply.) A. onlyThe incident metadata andDumps is storedinchThe Automatic Diagnostic Repository (ADR). B. The problemKey  isThe same asThe incident Number. C. theDatabaseSends an incident alert toThe Oracle Enterprise ManagerDatabaseHome page. D. Every problem has a problemKey, which isAtextstring that describes the problem. E. theDatabaseMakes an entry intoThe alertLog file  whenProblems andIncidents occur.

123.

123. What the statements is true regarding the recommendations received fromThe SQL Access Advisor? (Choose.) A. It cannot generate recommendations that support multiple workload queries. B. It can recommend partitioning onTables provided that the workloads hassomePredicates andjoins onThe columns ofThe Number orThe DATE type. C. It can recommend partitioning only  onTables that has at leastTen, therows. D. It can recommend onlyB-Tree indexes and  notBitmapor function-Based indexes.

124.

124. You are managing OracleDatabase11g withAn ASM storage withHigh redundancy. The following command was issued to DropThe disks fromThe DGADisk GroupAfter five hours:ALTERDiskGroup DGA OFFLINE DISKSinchFailgroup F2DROPAfter 5H; Which statement isTrueinchThis scenario? A. It starts the ASM fast mirror resync. B. AllThe disksinchThe DGADisk Groupwould be OFFLINE andThe Disk_repair_timeDiskAttribute would beSet  to 5hours. C. It drops All DiskPaths fromThe DGADisk Group. D. AllThe disksinchThe DGADisk Group inchFailureGroupF2 would be OFFLINE andThe Disk_repair_timeDiskAttribute would beSet  to 5Hours.

125.

 the. Which statement describes the significance ofThe Change FAILURE commandinchRMAN? (Choose Allthat apply.) A. It isUsed toChange failure priority only  forHighorLow priorities. B. It isUsed to ExecuteThe advised repair script. C. It isUsed toChange failure priority only  forThe CRITICAL priority. D. It isUsed toExplicitlyCloseTheOpenfailures. E. It isUsed toInform theDatabaseAbout the repair after the repair script executes.

053 (25)