Discussion
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
Answer: B
Correct answer: False
That describes SCROLL_LOCK, the pessimistic setting. Optimistic concurrency takes no lock while reading and merely checks at update time whether the row has changed since it was read, failing the update if it has. The assumption is that conflict is rare, which is what makes it the faster option when it holds.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development