ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam
Go to Exam

Exam 1z0-083 topic 1 question 148 discussion

Actual exam question from Oracle's 1z0-083
Question #: 148
Topic #: 1
[All 1z0-083 Questions]

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

  • A. They can be gathered by the DBMS_STATS package.
  • B. They are gathered by the SQL Tuning Advisor.
  • C. They provide real-time data about schema objects.
  • D. They are ignored by Optimizer if they are stale.
  • E. By default, they are automatically gathered by a maintenance job.
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
by RinD at May 11, 2021, 8:36 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
RinD
Highly Voted 3 years, 2 months ago
AE correct
upvoted 13 times
...
antonica
Most Recent 3 months, 2 weeks ago
what happend with this parameter, OPTIMIZER_REAL_TIME_STATISTICS?
upvoted 1 times
antonica
3 months, 2 weeks ago
Oracle Database 19c introduces real-time statistics, which extend online support to conventional DML statements. Because statistics can go stale between DBMS_STATS jobs, real-time statistics help the optimizer generate more optimal plans.
upvoted 1 times
...
...
_gio_
1 year ago
Selected Answer: AE
Sure of AE, Optimizer can use stale statistics this is why it's important to frequently analize them
upvoted 1 times
...
ScottL
1 year, 2 months ago
Selected Answer: AE
AE Correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statistics-concepts.html#GUID-3ED2DA31-F61B-4E8F-9166-79FB01392B1D
upvoted 1 times
...
flaviogcmelo
2 years, 3 months ago
Selected Answer: AE
Ref.: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statistics-concepts.html#GUID-3ED2DA31-F61B-4E8F-9166-79FB01392B1D
upvoted 3 times
...
ObserverPL
3 years, 1 month ago
Agree, AE correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago