Oracle
1Z0-052 · Question #201
Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #201. The question stem and answer options stay visible for context.
Managing Schema Objects
Question
Why does performance degrade when many UPDATE, INSERT or DELETE statements 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 after a DML operation
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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.
Topics
#bitmap index#DML performance#bitmap segment locking#index contention