Which two statements about the SQL Management Base (SMB) are true?

Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

A.
It is part of the data dictionary and stored in the SYSTEM tablespace.

B.
It contains the statement log, the plan history, plan baselines, and SQL profiles.

C.
It is part of the data dictionary and stored in the SYSAUX tablespace.

D.
It stores plans generated by the optimizer using a stored outline.

E.
It contains only SQL profiles generated by SQL Tuning Advisor.



Leave a Reply 0

Your email address will not be published. Required fields are marked *