___________ lock ensures that multiple updates cannot be made to the same resource at the same time.

Options
- Shared
- Exclusive
- Intent
- Schema

CORRECT ANSWER : Exclusive

Discussion Board
Explanation.

Answer : Exclusive.

When a transaction sets an exclusive lock on a database object, then the database object in question is available only to this transaction, and can only be changed by this transaction.
An exclusive lock is released using the Unlock Statement, by the database system at the end of the transaction in question.

Jayesh Sonar 03-2-2015 11:09 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲