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.
a shareable table lock for the table containing the row

B.
null lock on the table containing the row

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

D.
null lock on the row being updated

E.
ROW SHARE lock for the row being updated

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

G.
ROW EXCLUSIVE lock for the row being updated



Leave a Reply 1

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


Viki

Viki

Superb intaimofron here, ol’e chap; keep burning the midnight oil.