nerdexam
Oracle

1Z0-034 · Question #26

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…

The correct answer is A. The statistics are stored in the pending statistics table in the data dictionary. See the full explanation below for the reasoning.

Question

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?

Options

  • AThe statistics are stored in the pending statistics table in the data dictionary.
  • BThe statistics are treated as the current statistics by the optimizer for all sessions.
  • CThe statistics are treated as the current statistics by the optimizer for the current sessions only.
  • DThe statistics are temporary and used by the optimizer for all sessions until this session

How the community answered

(49 responses)
  • A
    78% (38)
  • B
    6% (3)
  • C
    4% (2)
  • D
    12% (6)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-034 Practice