Another user has gotten a lock using GET_LOCK. You inquire on the status of the lock by using

The correct answer is B. IS_FREE_LOCK C. IS_USED_LOCK. Two other functions are available for checking the status of advisory locks: IS_FREE_LOCK(lock_name) returns 1 if the name is not locked, 0 if it is locked, and NULL if an IS_USED_LOCK(lock_name) returns the connection ID of the client that holds the lock on the NULL if the…

Transactions and Locking

Question

Options

ARELEASE_LOCK
BIS_FREE_LOCK
CIS_USED_LOCK
DAnother GET_LOCK
ELOCK TABLES

How the community answered

(22 responses)

A
9% (2)
B
82% (18)
D
5% (1)
E
5% (1)

Explanation

Two other functions are available for checking the status of advisory locks: IS_FREE_LOCK(lock_name) returns 1 if the name is not locked, 0 if it is locked, and NULL if an IS_USED_LOCK(lock_name) returns the connection ID of the client that holds the lock on the NULL if the name is not locked.

Topics

#GET_LOCK#IS_FREE_LOCK#IS_USED_LOCK#user-level locking

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice