Oracle
1Z0-497 · Question #108
Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?
The correct answer is C. 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 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.
How the community answered
(62 responses)- A5% (3)
- B2% (1)
- C82% (51)
- D11% (7)
Community Discussion
No community discussion yet for this question.