Which type of lock would this scenario lead to?

The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?

The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?

A.
Exclusive table-level lock on the EMPLOYEES table

B.
Row-exclusive lock on the row being updated

C.
Null lock on the EMPLOYEES table

D.
Null lock on the row being updated



Leave a Reply 3

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