Oracle Exam 1Z0-083 Topic 7 Question 95 Discussion

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

Question #: 95
Topic #: 7

[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 Alpha at Jun 22, 2024, 08:50 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Hyman

5 months ago

Wait, there's a DBMS_STATE package? Is that the new cloud-based version of DBMS_STATS? Sign me up!

upvoted 0 times

Yvonne

3 months ago

They can be gathered by the DBMS_STATE package and by default, they are automatically gathered by a maintenance job.

upvoted 0 times

...

Regenia

4 months ago

Oh, I see. So, what are the two things that are true about Optimizer Statistics?

upvoted 0 times

...

Lauryn

4 months ago

Yes, there is a DBMS_STATE package. But it's not the same as DBMS_STATS.

upvoted 0 times

...

Ines

4 months ago

Optimizer statistics are important for query optimization and performance tuning.

upvoted 0 times

...

Celeste

4 months ago

No, DBMS_STATE is not the same as DBMS_STATS. They serve different purposes.

upvoted 0 times

...

Elinore

4 months ago

Yes, there is a DBMS_STATE package. It is used for managing optimizer statistics.

upvoted 0 times

...

Glennis

5 months ago

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

upvoted 0 times

...

Dottie

5 months ago

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

upvoted 0 times

...

Lazaro

5 months ago

I think A and D are true about Optimizer Statistics.

upvoted 0 times

...

Cassie

5 months ago

C is also a correct answer. The SQL Tuning Advisor can gather and analyze optimizer statistics as part of its tuning process.

upvoted 0 times

...

Jimmie

5 months ago

E is a bit tricky. Optimizer statistics provide historical data, not real-time data, about schema objects.

upvoted 0 times

Stephanie

4 months ago

E is a bit tricky. Optimizer statistics provide historical data, not real-time data, about schema objects.

upvoted 0 times

...

Fredric

5 months ago

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

upvoted 0 times

...

Isabella

5 months ago

A) They can be gathered by the DBMS_STATE package.

upvoted 0 times

...

Tiara

6 months ago

B is definitely false. Optimizer statistics are not ignored by the optimizer. They are crucial for query optimization.

upvoted 0 times

Tony

5 months ago

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

upvoted 0 times

...

Doug

5 months ago

A) They can be gathered by the DBMS_STATE package.

upvoted 0 times

...

Ashlyn

6 months ago

A and D seem to be the correct answers here. 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

Joanna

6 months ago

So, A and D are the correct options for Optimizer Statistics.

upvoted 0 times

...

Jenifer

6 months ago

Yes, that's right. There is a maintenance job that automatically gathers them by default.

upvoted 0 times

...

Alba

6 months ago

I think A and D are correct. The DBMS_STATS package gathers optimizer statistics.

upvoted 0 times

...