Which statement is true about the newly gathered statistics?

You are logged in as the HR user and you execute the following procedure:
SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘HR’, ‘EMPLOYEES’, ‘PUBLISH’, ‘FALSE’);
SQL> exec DBMS_STATS.GATHER_TABLE_STATS (‘HR’, ‘EMPLOYEES’);
Which statement is true about the newly gathered statistics?
A. They are temporary and purged when the session exits.
B. They are used by the optimizer for all sessions.
C. They are locked and cannot be overwritten.
D. They are marked as pending and stored in the pending statistics table.

Download Printable PDF. VALID exam to help you PASS.