Database-Management-System
December 10, 2023Database-Management-System
December 10, 2023Transactions
|
Question 58
|
A lock which required is not acquired by database engine is:
|
Row lock
|
|
|
Page lock
|
|
|
Table lock
|
|
|
Attribute lock
|
Question 58 Explanation:
→ Each transaction requests locks of different types on the resources, such as rows, pages, or tables, on which the transaction is dependent.
→ The locks block other transactions from modifying the resources in a way that would cause problems for the transaction requesting the lock.
→ Each transaction frees its locks when it no longer has a dependency on the locked resources.
→ The locks block other transactions from modifying the resources in a way that would cause problems for the transaction requesting the lock.
→ Each transaction frees its locks when it no longer has a dependency on the locked resources.
Correct Answer: D
Question 58 Explanation:
→ Each transaction requests locks of different types on the resources, such as rows, pages, or tables, on which the transaction is dependent.
→ The locks block other transactions from modifying the resources in a way that would cause problems for the transaction requesting the lock.
→ Each transaction frees its locks when it no longer has a dependency on the locked resources.
→ The locks block other transactions from modifying the resources in a way that would cause problems for the transaction requesting the lock.
→ Each transaction frees its locks when it no longer has a dependency on the locked resources.