Discussion
Which one is true statement :
Answer: A
Correct answer: With finer degree of granularity of locking a high degree of concurrency is possible
Locking a smaller unit - a row rather than a table - leaves more of the data free for other transactions, so concurrency rises; the cost is more locks to manage. The other statements are false: plain locking does not by itself prevent non-serializable schedules, field-level locking is possible, and an exclusive lock is refused while a shared lock is held.
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