多项选择题
Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)
A. Building the SQL profile
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans
相关考题
-
多项选择题
WhichthreestatementscorrectlydescribethefeaturesoftheI/Ocalibrationprocess？（）
A. Only one I/O calibration process can run at a time
B. It automates the resource allocation for the Automated Maintenance Tasks
C. It improves the performance of the performance-critical sessions while running
D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system
E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE -
单项选择题
Examine the parameter setting in your database: Which statement is correct about the database?（）
A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup -
单项选择题
You run the SQL Tuning Advisor （STA） to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement，which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile？（）
A. The tuned plan is not added to the SQL plan baseline.
B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
