Q1. Describe the purpose of checkpoint method. How frequently should checkpoints be performed? Explain how the frequency of checkpoints affects:
a) System performance if no failure takes place.
b) The time it takes to recover from system crash.
c) The time it takes to recover from disk crash.
Q2. What do you mean by cascading rollback? Explain why is it to be avoided?
Q3. Describe recovery by using deferred update method in both single user and multi-user atmosphere.
Q4. Describe the different control measures which are used to give security of data in databases.
Q5. Describe how the given differ: Fragmentation transparency, replication transparency and location transparency.
Q6. Describe the different concurrency control measures which are used in DBMS.
Q7. Differentiate between the OLTP and OLAP. As well in brief describe the need for incorporating the data cleaning unit in the data warehouse.
Q8. Write brief notes on any three of the given:
a) Data Mining
b) OLAP Servers
c) Conflict serializability
d) Multi-valued dependency