Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 782
|
Global locks
|
synchronize access to local resources
|
|
|
synchronize access to global resources
|
|
|
are used to avoid local locks
|
|
|
prevent access to global resources
|
Question 782 Explanation:
● Many of the resources protected by local locks in single-instance Oracle require global exposure in a parallel server database.
● Whenever one of these local locks is needed, a corresponding instance lock must be held as well, to protect the resource across all instances. The instance locks used to protect local locks globally are called global locks
● Whenever one of these local locks is needed, a corresponding instance lock must be held as well, to protect the resource across all instances. The instance locks used to protect local locks globally are called global locks
Correct Answer: B
Question 782 Explanation:
● Many of the resources protected by local locks in single-instance Oracle require global exposure in a parallel server database.
● Whenever one of these local locks is needed, a corresponding instance lock must be held as well, to protect the resource across all instances. The instance locks used to protect local locks globally are called global locks
● Whenever one of these local locks is needed, a corresponding instance lock must be held as well, to protect the resource across all instances. The instance locks used to protect local locks globally are called global locks