Q1. Describe the various states of a transaction. Describe the ACID properties of transactions. Why concurrency control method is required? Illustrate the problems that take place when the transactions are executed alongside?
Q2. Describe the Deffered and Immediate log based recovery scheme. Describe the main purpose of check point in such schemes?
Q3. Describe the steps comprised in knowledge discovery in databases?
Q4. Describe fragmentation transparency, replication transparency and location transparency in context of the distributed databases.
Q5. Describe the difference between the star schema, snowflake schema and fact constellations.
Q6. Write brief notes on any three:
a) Join Dependency and 5NF.
b) Database security.
c) Granularity of data items.
d) Conflict serializability of the schedules.