Which query should you use?
Which locking hint should you use in RetrieveProducts?
What should you do?
Which code segment should you use?
Which join predicate should you use?
Which Transact-SQL statement should you use?
Which transaction isolation level should you use?