DBMS Unit 5: Concurrency Control Technique Previous Year Questions

by
  1. What do you mean by concurrency control techniques?
  2. Write the comparison between single user and multi-user system.
  3. What do you mean by Transaction?
  4. Write the ACID property of Transaction.
  5. What is the need of concurrency control.
  6. Explain the lost update problem and dirty read problem.
  7. Describe the problem faced when concurrent transaction are executing in uncontrolled manner. Give an example and explain.
  8. Explain the working of locking technique in concurrency control. What benefits does Rigorous two-phase locking provide? How does it compare with other forms of two-phase locking?
  9. What is two phase locking? Describe with the help of an example. Will two phase locking result in deadlock? Justify your answer with the help of an example . Discuss the recovery with concurrent transactions also.
  10. What is two-phase locking protocol? List the salient features of strict two-phase locking protocol. Explain with a suitable example how cascading rollbacks can be avoided using strict two-phase locking.
  11. Write brief note about basic timestamp ordering.
  12. Discuss the important phases of optimistic concurrency control techniques. Write the advantages of using optimistic concurrency control techniques.
  13. What is multi version schemes of concurrency control? Discuss with the help of and example. Discuss the various time stamping protocols for concurrency control also.
  14. Explain the working of various time stamping protocols for concurrency control.
  15. What do you mean by Multiple Granularity ? Discuss with a suitable example . Discuss the validation based protocols also with a suitable example.
  16. Describe granularity locking. How does granularity of data items affect the performance of concurrency control?
  17. Discuss the working of multiple granularity schemes in concurrency control.
  18. Explain the UNDO/REDO recovery algorithm.
  19. Explain the UNDO/NO-REDO recovery algorithm.
  20. Explain the architecture of Oracle Database system.
  21. Discuss the Oracle data dictionary.
  22. Write and explain the various Oracle Process.
  23. What do you mean by PL/SQL block. Explain it with syntax.
  24. What do you mean by cursor? Write the various command to control cursor. Explain with example.