Oracle
1Z0-873 · Question #9
When you acquire an advisory lock using GET_LOCK(), the lock is released if
The correct answer is A. You issue another GET_LOCK() statement B. You issue a RELEASE_LOCK() statement C. Your connection to the server terminates. A client that has acquired an advisory lock can release it by calling RELEASE_LOCK(). An advisory lock also is released if the client makes another call to GET_LOCK() or closes its connection to the server.
JDBC
Question
When you acquire an advisory lock using GET_LOCK(), the lock is released if
Options
- AYou issue another GET_LOCK() statement
- BYou issue a RELEASE_LOCK() statement
- CYour connection to the server terminates
- DNone of the above
How the community answered
(27 responses)- A74% (20)
- D26% (7)
Explanation
A client that has acquired an advisory lock can release it by calling RELEASE_LOCK(). An advisory lock also is released if the client makes another call to GET_LOCK() or closes its connection to the server.
Topics
#advisory locks#GET_LOCK#RELEASE_LOCK#lock release
Community Discussion
No community discussion yet for this question.