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 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.



Leave a Reply 1

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


Jake from SF

Jake from SF

C and E are correct:

http://docs.oracle.com/cd/E25178_01/server.1111/e16638/optplanmgmt.htm

For C:
The SQL management base (SMB) is a part of the data dictionary that resides in the SYSAUX tablespace.

For E:
It stores statement logs, plan histories, SQL plan baselines, and SQL profiles. To allow weekly purging of unused plans and logs, the SMB uses automatic space management.