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

Clarinda

5 months ago

I agree with both of you. Options A and D seem to be the most likely correct answers.

upvoted 0 times

...

Glen

5 months ago

I believe option D is correct since Optimizer Statistics are automatically gathered by a maintenance job by default.

upvoted 0 times

...

Titus

5 months ago

I think option A is true because the DBMS_STATE package can gather Optimizer Statistics.

upvoted 0 times

...

Edelmira

6 months ago

If they are not gathered automatically, the SQL Tuning Advisor might be able to help optimize performance.

upvoted 0 times

...

Fausto

6 months ago

I'm not sure either, Janella. Let's look it up.

upvoted 0 times

...

Janella

6 months ago

I'm not sure about C. Does the SQL Tuning Advisor gather them?

upvoted 0 times

...

Jeffrey

7 months ago

I think E is also true. It provides real-time data about schema objects.

upvoted 0 times

...

Edelmira

7 months ago

I agree with you, Fausto. The DBMS_STAT package can gather them and they are automatically gathered by a maintenance job.

upvoted 0 times

...

Fausto

7 months ago

I think A and D are true.

upvoted 0 times

...

Phung

8 months 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

8 months ago

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

upvoted 0 times

...

Carla

8 months 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

8 months 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

8 months 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

8 months 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

...