You executed the following commands: SQL> ALTER SESSION SET
OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE
DBMS_STATS.SET_TABLE_PREFS(‘SH’, ‘CUSTOMERS’, ‘PUBLISH’,’false’); SQL>
EXECUTE DBMS_STATS.GATHER_TABLE_STATS(‘SH’, ‘CUSTOMERS’); Which
statement is correct regarding the above statistics collection on the SH.CUSTOMERS table
in the above session?
A.
The statistics are temporary and used by the optimizer for all sessions until this session
terminates.
B.
The statistics are treated as the current statistics by the optimizer for the current sessions
only.
C.
The statistics are stored in the pending statistics table in the data dictionary.
D.
The statistics are treated as the current statistics by the optimizer for all sessions.