nerdexam
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)
  • A
    5% (3)
  • B
    2% (1)
  • C
    82% (51)
  • D
    11% (7)

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice