Order PDF of any content from our website with a little minor Fee to donate for hard work. Online MCQs are fully free but PDF books are paid. For details: contact whatsapp +923028700085 Important notes based PDF Books are available in very little price, starting from 500/-PKR; Order Now: contact whatsapp +923028700085

NSCT – Concurrency Control MCQs

20 min Score: 0 Attempted: 0/20 Subscribe
1. . Concurrency control in DBMS is used to:





2. . The main goal of concurrency control is:





3. . Serializability is:





4. . A schedule is:





5. . Conflict occurs when:





6. . A conflict-serializable schedule is:





7. . Lost update problem occurs when:





8. . Dirty read occurs when:





9. . Non-repeatable read occurs when:





10. . Phantom problem occurs when:





11. . Two-phase locking (2PL) ensures:





12. . Strict two-phase locking (Strict 2PL) requires:





13. . Deadlock occurs when:





14. . To prevent deadlock, one can use:





15. . Timestamp-based protocols assign:





16. . Multiversion concurrency control (MVCC) allows:





17. . Read-write conflict occurs when:





18. . Write-write conflict occurs when:





19. . Optimistic concurrency control assumes:





20. . The main purpose of Concurrency Control is to:





Contents Copyrights Reserved By T4Tutorials