What should you include in the query?

You are creating a new update query. You need to ensure that the query terminates if a
shared lock is encountered white the data is updating. What should you include in the
query?

A.
sp_lock

B.
WITH (NOWAIT)

C.
sp_who

D.
OPTION (MERGE JOIN)