255.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.
Answer: CE
关于SQL管理库(SMB),哪两个语句是正确的?
1、作为数据字典的一部分,存储在SYSAUX表空间中;
2、包含语句日志,计划历史,计划基线,和SQL Profile。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2124444/
,如需转载,请注明出处,否则将追究法律责任。