C2090-610: DB2 10.1 Fundamentals
C2090-610: DB2 10.1 Fundamentals practice questions, page 6 of 6, with answer review and explanations.
Question 26
When is an INTENT EXCLUSIVE (IX) lock required?
- When a transaction intends to read or change data.
- When a transaction intends to change but not read data.
- When a transaction intends to read but not change data.
- When a transaction intends to change the system catalog.
Question 27
What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?
- Lock escalation
- Lock substitution
- Lock switch/exchange
- Lock conversion/promotion