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

Previous Question
Next Question

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

Previous Question
Next Question

Leave a Reply

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