Oracle Exam 1Z0-083 Topic 1 Question 89 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 89
Topic #: 1

[All 1Z0-083 Questions]

Which two arc true about Optimizer Statistics ?

AThey can be gathered by the DBMS_STATE package.

BThey are ignored by Optimizer if they are state.

CThey are gathered by the SQL Tuning Advisor.

DBy default, they are automatically gathered by a maintenance job.

EThey provide real-time data about schema objects.

Show Suggested Answer

Suggested Answer: A, D

by Tyra at Apr 11, 2024, 05:57 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-083 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Fausto

3 hours ago

I think A and D are true.

upvoted 0 times

...

Phung

22 days ago

Okay, let's go through the options one by one. A is definitely true, the DBMS_STATS package is used to gather optimizer statistics.

upvoted 0 times

...

Danilo

24 days ago

Hmm, you might be right. I'm not entirely sure about that one. Let's keep thinking it through.

upvoted 0 times

...

Carla

25 days ago

Hold on, I'm not so sure about B. I thought the optimizer always uses the statistics, even if they're stale.

upvoted 0 times

...

Ronny

26 days ago

Yeah, A and D sound right to me. The DBMS_STATS package is used to gather optimizer statistics, and there is a maintenance job that automatically gathers them by default.

upvoted 0 times

...

Verlene

28 days ago

I agree, this question seems a bit obscure. But let's try to work through it together. I think the answer is A and D.

upvoted 0 times

...

Irving

30 days ago

I don't like this question. It's too technical and specific, and I'm not sure I have a good understanding of optimizer statistics.

upvoted 0 times

...