Q1. What do you mean by check points and why are they significant? List all the actions taken by the recovery manager throughout the check points.
Q2. Illustrate the key properties of the long duration transactions? How does the concurrency protocol influence the long duration transactions?
Q3. Illustrate the various types of joins in the SQL?
Q4. What is ‘Two-Phase locking protocol’? Describe with the help of an illustration of a schedule, how the protocol makes sure a schedule to be conflict-serializable, however not cascade-less?
Q5. Write brief notes on the given:
a) Data Mining.
b) Distributed Transactions.
c) OLTP and OLAP