Question 1:
Discuss and describe the classification of DBMS based upon location of database.
Question 2:
Illustrate with illustrations different SQL commands employed for creating and deleting relations. Write down a brief note on ACID properties of transaction model.
Question 3:
Illustrate out the term functional dependency. Provide examples. Also describe 1st, 2nd and 3rd normal Forms.
Question 4:
Illustrate the different heuristics which are involved in query optimization. Also illustrate the different algorithms for executing query operations.
Question 5:
Illustrate the most significant classes of parallel machines.
Question 6:
How is two (2) phases locking method employed to ensure serializability? Discuss.