Which type of lock is obtained when using a ‘WITH UR’ clause on an SQL SELECT statement in a data-sharing environment?

Which type of lock is obtained when using a ‘WITH UR’ clause on an SQL SELECT statement in a data-sharing environment?
A . U-lock
B . S-lock
C . P-lock
D . No lock is obtained

View Answer

Answer: D