PTU M.Tech CSE IT Engineering 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 CSE IT Engineering Question Paper 2012 for all students Previous Year old Past Papers of PTU M.Tech CSE IT Engineering Paper 2012 Advanced Database Management Systems Punjab Technical University September 2012 and March 2012 Exam M.Tech CSE IT Engineering Sample Model Question Papers Free Download PDF
Advanced Database Management Systems
Q 1) (a) Discuss different types of database management systems with advantages and disadvantages of each.
(b) Why the normalisation process is necessary for a good database design? Discuss in detail the Boyee-Codd normal form with suitable example.
Q2) What are different types of relational query languages? Discuss the different techniques for optimising the queries.
Q3) What are the different techniques for database recovery? Discuss in detail.
Q4) (a) What are the different advantages of a distributed dtitabase management system? Discuss in detail the different functions of a DDBMS to manage the complexity of data distribution.
(b) Discuss in detail concurrency control in case of distributed database management systems.
Q5) (a) How the object oriented databases are beneficial than the traditional databases? Explain the different concepts of object oriented database management systems.
(b) Write short note on deductive databases
Q 6) What is the use of data warehouse? Discuss the architecture of data warehouse and its functionality in detail.
PTU M.Tech CSE IT Engineering Paper 2012 Advanced Database Management Systems