You executed the following commands:SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;SQL> EXECUTE DBMS_ST

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You executed the following commands:SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;SQL> EXECUTE DBMS_ST

Post by answerhappygod »

You executed the following commands:SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SHI, 'CUSTOMERS','PUBLISH'.'false');SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');Which statement is correct regarding the above statistics collection on theSH.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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply