Oracle
1Z0-417 · Question #88
1Z0-417 Question #88: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-417 to reveal the answer and full explanation for question #88. The question stem and answer options stay visible for context.
Question
Which are two characteristics of "invisible" index functionality that would help tune a database having thousands of legacy indexes?
Options
- AAn invisible index is ignored by the optimizer.
- BAfter an index becomes invisible, it is no longer maintained during inserts and updates.
- CI/O bottlenecks are easy to spot when invisible indexes are used.
- DAn index only needs to be rebuilt for it to be visible again.
- EThe session or system parameter needs to be changed to
Unlock 1Z0-417 to see the answer
You've previewed enough free 1Z0-417 questions. Unlock 1Z0-417 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.