本文探讨了SQL管理基（SMB）的两个关键事实：SMB不仅包含SQL配置文件，还涉及语句日志、计划历史记录、计划基线等内容；此外，SMB作为数据词典的一部分，被存储在SYSAUX表空间中。
QUESTION 4
Which two statements about the SQL Management Base (SMB) are true? (Choose two.)
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 two statements about the SQL Management Base (SMB) are true? (Choose two.)
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.
Correct Answer: CE
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
