多项选择题
Which two statements about the SQL Management Base （SMB） are true？（）
A. It contains only SQL profiles generated by SQL Tuning Advisor.
B. It stores plans generated by the optimizer using a stored outline.
C. It is part of the data dictionary and stored in the SYSAUX tablespace.
D. It is part of the data dictionary and stored in the SYSTEM tablespace.
E. It contains the statement log，the plan history，plan baselines，and SQL profiles.
相关考题
-
多项选择题
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
