Discussion
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Answer: C
Correct answer: Repeatable read
Repeatable read holds read locks to the end of the transaction, so a row once read cannot be changed by another transaction and dirty and nonrepeatable reads are both prevented. It does not lock rows that do not yet exist, so another transaction may still insert one and a phantom read remains possible.
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