Oracle
1Z0-050 · Question #39
Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?
The correct answer is A. The smallest amount of a bitmap that can be locked is a bitmap segment. See the full explanation below for the reasoning.
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 smallest amount of a bitmap that can be locked is a bitmap segment
- BAdditional time is taken to remove NULL values from the bitmap index after a DML operation
- CThe DML operations re-create the bitmap index blocks
- DThe bitmap index is rebuilt automatically after a DML operation
How the community answered
(51 responses)- A75% (38)
- B4% (2)
- C6% (3)
- D16% (8)
Community Discussion
No community discussion yet for this question.