【单选题】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...
A.
The statistics are stored in the pending statistics table in the data dictionary.
B.
The statistics are treated as the current statistics by the optimizer for all sessions.
C.
The statistics are treated as the current statistics by the optimizer for the current sessions only.
D.
The statistics are temporary and used by the optimizer for all sessions until this session terminates.
【单选题】You executed the following commands: Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?()
A.
The statistics are stored in the pending statistics table in the data dictionary.
B.
The statistics are treated as the current statistics by the optimizer for all sessions.
C.
The statistics are treated as the current statistics by the optimizer for the current sessions only.
D.
The statistics are temporary and used by the optimizer for all sessions until this session terminates.
【单选题】听力原文:W: Mary wants to take statistics this year, but according to the requirements, she has to take the accounting course first. M: She may ask Professor Lee Smith if she could take them simultaneousl...
A.
Professor Smith will help Mary to take the course simultaneously.
B.
Mary will probably postpone taking the course of statistics.
C.
Mary will require taking the accounting course first.