Oracle Exam 1Z0-908 Topic 5 Question 84 Discussion

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

Question #: 84
Topic #: 5

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 Jeanice at Jul 12, 2024, 04:06 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Stevie

4 months ago

This question is a real pearl of wisdom! I think I'll go with option B. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine. It just makes sense, doesn't it?

upvoted 0 times

...

Nan

4 months ago

Option A seems to be the correct answer. Updating index statistics is an I/O expensive operation, which is true for InnoDB persistent index statistics.

upvoted 0 times

Samira

3 months ago

Definitely. It's important to consider the impact on I/O when updating index statistics.

upvoted 0 times

...

Alaine

3 months ago

So, does that mean we should be cautious when updating index statistics?

upvoted 0 times

...

Mariko

3 months ago

Yes, that's right. It can be a costly operation in terms of I/O.

upvoted 0 times

...

Kasandra

3 months ago

I think option A is correct. Updating index statistics is indeed I/O expensive.

upvoted 0 times

...

Glory

4 months ago

Haha, this question is a real brain-teaser! I'm going to go with option D. Execution plans based on transient index statistics must improve precision when innodb_stats_persistent_sample_pages is increased. Or maybe not, who knows?

upvoted 0 times

Frederica

4 months ago

I'm not so sure about that. I believe option E is the correct one. Increasing innodb_stats_persistent_sample_pages might determine higher pages scanning speed, but it also comes with increased memory usage.

upvoted 0 times

...

Alline

4 months ago

I think option D is correct. It does make sense that increasing innodb_stats_persistent_sample_pages would improve precision in execution plans.

upvoted 0 times

...

Emilio

4 months ago

I'm not sure about the correct answer, but option E sounds plausible. Increasing innodb_stats_persistent_sample_pages could determine higher pages scanning speed, at the cost of increased memory usage.

upvoted 0 times

...

Ceola

5 months ago

I think option C is correct. The question is about InnoDB persistent index statistics, and setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

upvoted 0 times