Why would you want to create a table with a lock mode row as opposed to a lock mode page?

Question

Options

• Ato reduce disk I/O
• Bto keep more information in memory for each locked row
• Cto increase concurrency among multiple users on the same table
• Dto reduce the number of locks when accessing rows out of the table

• A
  3% (1)
• B
  15% (6)
• C
  74% (29)
• D
  8% (3)

No community discussion yet for this question.