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?

The correct answer is A. WITH (NOWAIT). See the full explanation below for the reasoning.

Question

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?

Options

AWITH (NOWAIT)
Bsp_who
COPTION (MERGE JOIN)
Dsp_lock

How the community answered

(26 responses)

A
81% (21)
B
4% (1)
C
4% (1)
D
12% (3)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice