Question 1 Discuss the classification of DBMS based on location of database
Question 2 Explain with examples different SQL commands used for creating and deleting relations. Write a short note on ACID properties of transaction model
Question 3 Define functional dependency. Give examples. Also describe 1st, 2nd and 3rd normal Forms
Question 4 Explain the various heuristics involved in query optimization. Also describe the various algorithms for executing query operations
Question 5 Describe the most important classes of parallel machines
Question 6 How is two phase locking method used to ensure serializability? Illustrate