Oracle
1Z0-050 · Question #77
Which two statements about the SQL Management Base (SMB) are true? (Choose two.)
The correct answer is C. It is part of the data dictionary and stored in the SYSAUX tablespace. E. It contains the statement log, the plan history, plan baselines, and SQL profiles. See the full explanation below for the reasoning.
Question
Which two statements about the SQL Management Base (SMB) are true? (Choose two.)
Options
- AIt contains only SQL profiles generated by SQL Tuning Advisor.
- BIt stores plans generated by the optimizer using a stored outline.
- CIt is part of the data dictionary and stored in the SYSAUX tablespace.
- DIt is part of the data dictionary and stored in the SYSTEM tablespace.
- EIt contains the statement log, the plan history, plan baselines, and SQL profiles.
How the community answered
(40 responses)- A3% (1)
- B8% (3)
- C75% (30)
- D15% (6)
Community Discussion
No community discussion yet for this question.