单项选择题
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?()
A. SQL statements that are part of the AWR baseline only
B. SQL statements based on the AWR top SQL identification
C. SQL statements that are part of the available SQL Tuning Set (STS) only
D. SQL statements that are available in the cursor cache and executed by a user other than SYS
相关考题
-
多项选择题
WhichtwochangesandtheireffectonthesystemcanbetestedbyusingtheDatabaseReplayfeature?()
A. multiplexing of the control file
B. adding the redo log member to the database
C. database and operating system upgrades
D. changing the database storage to ASM-managed storage -
多项选择题
WhichtwoaretheusesoftheASMmetadatabackupandrestore(AMBR)feature?()
A. It can be used to back up all data on ASM disks.
B. It can be used to recover the damaged ASM disk group along with the data.
C. It can be used to gather information about a preexisting ASM disk group with disk paths,disk name,failure groups,attributes templates,and alias directory structure.
D. It can be used to re-create the ASM disk group with its attributes. -
多项选择题
WhichtaskscanbeaccomplishedusingtheEnterpriseManagerSupportWorkbenchinOracleDatabase11g?()
A. Generate reports on data failure such as data file failures.
B. You can track the Service Request (SR) and implement repairs.
C. You can package and upload diagnostic data to Oracle Support.
D. You can manually run health checks to gather diagnostic data for a problem.
