When is an INTENT EXCLUSIVE (IX) lock required?
A.
When a transaction intends to change the system catalog.
B.
When a transaction intends to read or change data.
C.
When a transaction intends to change but not read data.
D.
When a transaction intends to read but not change data.
Explanation:
IX lock (intent exclusive)
The lock owner and concurrent processes can read and change data in the table, partition, or table space. The lock owner might acquire a page or row lock on any data it reads; it must acquire one on any data it changes.
0
0