What are the two types of locks that this scenario would lead to?

User Scott has updated the salary of one of the employees in the EMPLOYEES table and
has not committed the transaction. What are the two types of locks that this scenario would
lead to? (Choose two.)

User Scott has updated the salary of one of the employees in the EMPLOYEES table and
has not committed the transaction. What are the two types of locks that this scenario would
lead to? (Choose two.)

A.
ROW EXCLUSIVE lock for the row being updated

B.
exclusive table-level lock for the table containing the row

C.
shared row-exclusive lock for the row being updated

D.
null lock on the table containing the row

E.
null lock on the row being updated

F.
ROW SHARE lock for the row being updated

G.
a shareable table lock for the table containing the row



Leave a Reply 1

Your email address will not be published. Required fields are marked *