1Z0-536 · Question #69
Your customer is moving their application to an Exadata environment from a standard Oracle environment. What three changes might you expect to make to optimize performance and resource usage in the…
The correct answer is A. You will add Indexes to your tables for better performance. B. You should consider implementing a different partitioning strategy. C. You should consider reducing the number of materialized views. A: In Oracle Database 11gR2 a new feature called the Exadata Storage Index has been introduced. The storage index contains a summary of the data distribution on the disk and provides an additional method to eliminate unnecessary disk IO. B: Make use of Exadata Storage Server…
Question
Your customer is moving their application to an Exadata environment from a standard Oracle environment. What three changes might you expect to make to optimize performance and resource usage in the new environment?
Options
- AYou will add Indexes to your tables for better performance.
- BYou should consider implementing a different partitioning strategy.
- CYou should consider reducing the number of materialized views.
- DYou should make the extents larger, such as 8 MBs.
How the community answered
(21 responses)- A71% (15)
- D29% (6)
Explanation
A: In Oracle Database 11gR2 a new feature called the Exadata Storage Index has been introduced. The storage index contains a summary of the data distribution on the disk and provides an additional method to eliminate unnecessary disk IO. B: Make use of Exadata Storage Server Grid 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, 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.