C2090-610

C2090-610 practice questions, page 6 of 6, with answer review and explanations.

Question 26

When is an INTENT EXCLUSIVE (IX) lock required?

  1. When a transaction intends to read or change data.
  2. When a transaction intends to change but not read data.
  3. When a transaction intends to read but not change data.
  4. 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?

  1. Lock escalation
  2. Lock substitution
  3. Lock switch/exchange
  4. Lock conversion/promotion