How many locks will be used on tab1 to run the query?

Given the following:

How many locks will be used on tab1 to run the query?
A . 0
B . 1
C . 2
D . Depends on the number of index pages accessed

View Answer

Answer: A