- What do you mean by concurrency control techniques?
- Write the comparison between single user and multi-user system.
- What do you mean by Transaction?
- Write the ACID property of Transaction.
- What is the need of concurrency control.
- Explain the lost update problem and dirty read problem.
- Describe the problem faced when concurrent transaction are executing in uncontrolled manner. Give an example and explain.
- 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?
- 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.
- 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.
- Write brief note about basic timestamp ordering.
- Discuss the important phases of optimistic concurrency control techniques. Write the advantages of using optimistic concurrency control techniques.
- 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.
- Explain the working of various time stamping protocols for concurrency control.
- What do you mean by Multiple Granularity ? Discuss with a suitable example . Discuss the validation based protocols also with a suitable example.
- Describe granularity locking. How does granularity of data items affect the performance of concurrency control?
- Discuss the working of multiple granularity schemes in concurrency control.
- Explain the UNDO/REDO recovery algorithm.
- Explain the UNDO/NO-REDO recovery algorithm.
- Explain the architecture of Oracle Database system.
- Discuss the Oracle data dictionary.
- Write and explain the various Oracle Process.
- What do you mean by PL/SQL block. Explain it with syntax.
- What do you mean by cursor? Write the various command to control cursor. Explain with example.
