本文探讨了SQL管理基础(SMB)的两个核心事实：SMB不仅包含由SQL调优顾问生成的SQL配置文件，还包括语句日志、计划历史记录、计划基线等内容；此外，SMB作为数据字典的一部分被存储在SYSAUX表空间中。
QUESTION 204
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 astored 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.
Answer: CE
同255题：http://blog.csdn.net/rlhua/article/details/14090391
Explanation/Reference:
Section: Managing Database Performance & Tuning
扫一扫
1530
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
