Oracle
1Z0-497 · Question #108
1Z0-497 Question #108: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-497 to reveal the answer and full explanation for question #108. The question stem and answer options stay visible for context.
Question
Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?
Options
- AThe DML operations re-create the bitmap index blocks.
- BThe bitmap index is rebuilt automatically after a DML operation.
- CThe smallest amount of a bitmap that can be locked is a bitmap segment.
- DAdditional time is taken to remove NULL values from the bitmap index alter a DML operation.
Unlock 1Z0-497 to see the answer
You've previewed enough free 1Z0-497 questions. Unlock 1Z0-497 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.