Oracle
1Z0-908 · Question #42
1Z0-908 Question #42: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-908 to reveal the answer and full explanation for question #42. The question stem and answer options stay visible for context.
Question
Which statement is true about InnoDB persistent index statistics?
Options
- 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
- CSetting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new
- DExecution plans based on transient index statistics improve precision when
- EIncreasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at
- FTables are scanned and index statistics recalculated when an instance is restarted.
Unlock 1Z0-908 to see the answer
You've previewed enough free 1Z0-908 questions. Unlock 1Z0-908 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.