nerdexam
IBM

C2090-610 · Question #92

When is an INTENT EXCLUSIVE (IX) lock required?

The correct answer is A. When a transaction intends to read or change data. See the full explanation below for the reasoning.

Question

When is an INTENT EXCLUSIVE (IX) lock required?

Options

  • AWhen a transaction intends to read or change data.
  • BWhen a transaction intends to change but not read data.
  • CWhen a transaction intends to read but not change data.
  • DWhen a transaction intends to change the system catalog.

How the community answered

(25 responses)
  • A
    80% (20)
  • B
    4% (1)
  • C
    4% (1)
  • D
    12% (3)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice