PTU M.Tech Paper 2012 Advanced Database Management Systems Punjab Technical University Exam 2012 Advanced Database Management Systems Test September and March Question Paper Free Download Punjab Technical University Advanced Database Management Systems Question Papers 2012 PTU M.Tech Question Paper 2012 for all students Previous Year old Past Papers of PTU M.Tech Paper 2012 Advanced Database Management Systems Punjab Technical University September 2012 and March 2012 Exam M.Tech Sample Model Question Papers Free Download PDF
Advanced Database Management Systems
Q1) (a) What are the different advantages of Database Management System over the traditional file processing system for managing data?
(b) What do you mean by isolation property of two concurrently executing transactions? Discuss the concurrency control based on time stamp ordering.
Q2) Discuss in detail the different types of relational query languages used for RDBMS. Explain different techniques for query optimization.
Q3) How the normalization is important for good database design? What is the role of functional dependencies for the normalisation process? Discuss the different normal forms with the help of examples.
Q4) (a) Discuss the important functions of a distributed database management system for managing the complexity of data distribution. What are the different methods for data distribution?
(b) How a distributed database system can be recovered in case of failure?
Q5) Discuss the different concepts of Object Oriented Database Management System those make it beneficial for certain applications than the other database management systems. Explain the complexities of 00DB MS than the other DBMS indetail.
Q6) (a) How a data warehouse is different from a database? Explain the designing of a data warehruse.
(b) Discuss in detail the deductive databases.
PTU M.Tech Paper 2012 Advanced Database Management Systems