Oracle Exam 1Z0-083 Topic 8 Question 99 Discussion

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

Question #: 99
Topic #: 8

[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 William at Aug 05, 2024, 01:43 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Leonor

3 months ago

I believe E is also true. Optimizer Statistics provide real-time data about schema objects.

upvoted 0 times

...

Gennie

3 months ago

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

upvoted 0 times

...

Lynna

3 months ago

I think A and D are true about Optimizer Statistics.

upvoted 0 times

...

Aileen

3 months ago

That makes sense. So, A, D, and E are true about Optimizer Statistics.

upvoted 0 times

...

Esteban

3 months ago

Optimizer statistics? More like optimizer guesstimates, am I right? But seriously, D and E are the way to go.

upvoted 0 times

...

Willard

3 months ago

Wait, so the DBMS_STATS package is different from the SQL Tuning Advisor? I'm getting a bit confused here.

upvoted 0 times

Cortney

2 months ago

C) They are gathered by the SQL Tuning Advisor.

upvoted 0 times

...

Andra

3 months ago

A) They can be gathered by the DBMS_STATE package.

upvoted 0 times

...

Colby

3 months ago

I believe E is also true. Optimizer Statistics provide real-time data about schema objects.

upvoted 0 times

...

Minna

3 months ago

Haha, the SQL Tuning Advisor? That's like using a sledgehammer to crack a nut. I think C is definitely wrong.

upvoted 0 times

Estrella

3 months ago

E) They provide real-time data about schema objects.

upvoted 0 times

...

Estrella

3 months ago

D) By default, they are automatically gathered by a maintenance job.

upvoted 0 times

...

Lavonna

3 months ago

A) They can be gathered by the DBMS_STATE package.

upvoted 0 times

...

Kimberely

4 months ago

I'm pretty sure B is also true. The optimizer doesn't ignore the statistics, but it will use them even if they are stale.

upvoted 0 times

Jodi

3 months ago

I'm pretty sure B is also true. The optimizer doesn't ignore the statistics, but it will use them even if they are stale.

upvoted 0 times

...

Fletcher

3 months ago

D) By default, they are automatically gathered by a maintenance job.

upvoted 0 times

...

Levi

3 months ago

A) They can be gathered by the DBMS_STATE package.

upvoted 0 times

...

Almeta

4 months ago

I agree with you, Aileen. Optimizer Statistics are automatically gathered by a maintenance job.

upvoted 0 times

...

Armando

4 months ago

D and E seem to be the correct answers. The DBMS_STATS package is used to gather optimizer statistics, and the maintenance job automatically gathers them by default.

upvoted 0 times

Latrice

3 months ago

Exactly. That's why they are important for the optimizer to make efficient execution plans.

upvoted 0 times

...

Lamar

3 months ago

So, they provide real-time data about schema objects, right?

upvoted 0 times

...

Leonardo

3 months ago

Yes, that's right. The DBMS_STATS package is used to gather those statistics.

upvoted 0 times

...

Sylvia

4 months ago

I think D and E are correct. The maintenance job gathers optimizer statistics automatically.

upvoted 0 times

...

Aileen

4 months ago

I think A and D are true.

upvoted 0 times

...