Oracle Exam 1Z0-908 Topic 11 Question 82 Discussion

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

Question #: 82
Topic #: 11

Which statement is true about InnoDB persistent index statistics?

AUpdating index statistics is an I/O expensive operation.

BIndex statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

CSetting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

DExecution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

EIncreasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

Show Suggested Answer

Suggested Answer: A

by Lera at Jul 02, 2024, 03:24 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Jaime

5 months ago

I think D makes sense because transient index statistics can improve precision.

upvoted 0 times

...

Linette

5 months ago

Hmm, I'm leaning towards option D. Transient index statistics might not be as accurate, so increasing the sample pages could improve the precision of the execution plans.

upvoted 0 times

Demetra

3 months ago

So, increasing innodb_stats_persistent_sample_pages could be beneficial for performance.

upvoted 0 times

...

Timmy

3 months ago

I agree, accuracy is important for execution plans.

upvoted 0 times

...

Alyce

3 months ago

I think option D makes sense. More sample pages could help with accuracy.

upvoted 0 times

...

Lashaunda

4 months ago

That's true. We need to consider the trade-off between precision and memory usage.

upvoted 0 times

...

Xuan

4 months ago

But doesn't option E mention that increasing sample pages also increases memory usage?

upvoted 0 times

...

Verdell

4 months ago

I think option D makes sense. More sample pages could help with accuracy.

upvoted 0 times

...

Bambi

5 months ago

But updating index statistics is costly, so A could also be correct.

upvoted 0 times

...

Daniela

5 months ago

I disagree, I believe it's C.

upvoted 0 times

...

Bambi

5 months ago

I think the correct answer is B.

upvoted 0 times

...

Rosalia

5 months ago

I'm not sure about the correct answer, but option E sounds a bit funny. Increasing the sample pages could increase memory usage? That seems counterintuitive.

upvoted 0 times

...

Billye

5 months ago

Option C seems like the right answer to me. Setting innodb_stats_auto_recalc=ON should automatically update the statistics when a new index is created.

upvoted 0 times