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

Posted by: Pdfprep Category: C2090-320 Tags: C2090-320 practice exam, IBM Certified Database Administrator, C2090-320 exam questions Post Date: December 30, 2020

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

Answer: D

Author

Pdfprep