1Z0-417 · Question #88
Which are two characteristics of "invisible" index functionality that would help tune a database having thousands of legacy indexes?
The correct answer is A. An invisible index is ignored by the optimizer. E. The session or system parameter needs to be changed to. Exam Questions, Study Guides, Practice Tests. Lead the way to help you pass any IT Certification exams, 100% Pass Guaranteed or Full Refund. Especially Cisco, Microsoft, CompTIA, Citrix, EMC, HP, Oracle, VMware, Juniper, Check Point, LPI, Nortel, EXIN and so on. Our Slogan…
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
How the community answered
(37 responses)- A78% (29)
- B14% (5)
- C5% (2)
- D3% (1)
Explanation
Exam Questions, Study Guides, Practice Tests. Lead the way to help you pass any IT Certification exams, 100% Pass Guaranteed or Full Refund. Especially Cisco, Microsoft, CompTIA, Citrix, EMC, HP, Oracle, VMware, Juniper, Check Point, LPI, Nortel, EXIN and so on. Our Slogan: First Test, First Pass. Help you to pass any IT Certification exams at the first try. You can reach us at any of the email addresses listed below. Any problems about IT certification or our products, you could rely upon us, we will give you satisfactory answers in 24 hours.
Topics
Community Discussion
No community discussion yet for this question.