nerdexam
Oracle

1Z0-083 · Question #170

Which two are true about Optimizer Statistics? (Choose two.)

The correct answer is A. They can be gathered by the DBMS_STATS package. E. By default, they are automatically gathered by a maintenance job. https://docs.oracle.com/database/121/TGSQL/tgsql_stats.htm#TGSQL-GUID-E4EFD512-EAF9- 4AF3-943F-FDEC7E47B23C

Manage Database Performance

Question

Which two are true about Optimizer Statistics? (Choose two.)

Options

  • AThey can be gathered by the DBMS_STATS package.
  • BThey are gathered by the SQL Tuning Advisor.
  • CThey provide real-time data about schema objects.
  • DThey are ignored by Optimizer if they are stale.
  • EBy default, they are automatically gathered by a maintenance job.

How the community answered

(29 responses)
  • A
    72% (21)
  • B
    17% (5)
  • C
    7% (2)
  • D
    3% (1)

Explanation

https://docs.oracle.com/database/121/TGSQL/tgsql_stats.htm#TGSQL-GUID-E4EFD512-EAF9- 4AF3-943F-FDEC7E47B23C

Topics

#optimizer statistics#DBMS_STATS#automatic statistics gathering#maintenance job

Community Discussion

No community discussion yet for this question.

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