CS 9221 / 241204 Database Technology question paper – June 2012

CS 9221 / 241204 Database Technology question paper – June 2012 / Anna University Previous Year Exam Questions / Anna University Previous Year M.E. M.Tech. Computer Science and Information Technology Question Papers

Question Paper Code : 81230 M.E. DEGREE EXAMINATION, JUNE 2012 Second Semester Computer Science and Engineering CS 9221 / 241204 / 8241204 CS 921 — DATABASE TECHNOLOGY (Common to M.E. Computer Science and Engineering) (Regulation 2009) Time: Three hours                                                       Maximum: 100 Marks Answer ALL Questions PART A — (10 × 2 = 20 Marks) 1. What are the Distributed databases? 2. Define Concurrency control. 3. What are Object Oriented Databases? 4. What is Persistence? 5. Define Data Mining. 6. Give two features of Mobile Databases. 7. Define Normalization. 8. Define Integrity. 9. What are Active Databases? 10. Give two features of text database. PART B — (5 × 16 = 80 Marks) 11. (a) (i) Compare Distributed Databases and Conventional Databases. (10) (ii) Explain Query Processing. (6) Or (b) (i) Describe the architecture of Distributed Databases. (8) (ii) Explain Transaction Processing and Concurrency Control. (8) 12. (a) Give a brief account on Approaches, Modeling and Design of Object Oriented Databases. (16) Or (b) Discuss about: (i) Persistence (4) (ii) Multiversion locks (8) (iii) Recovery (4) 13. (a) Discuss about Web databases and Mobile databases. (16) Or (b) Give a brief account on Data Warehousing and Data Mining. (16) 14. (a) (i) Explain E-R model with an example. (8) (ii) Discuss about Database Tuning. (8) Or (b) Describe the design of Temporal Databases and Spatial Databases. (16) 15. (a) Discuss about Deductive databases and Spatial database. (16) Or (b) Explain the features of Multimedia databases and Image databases. (16) ____________________

CS 9221 Database Technology question paper – June 2010

CS 9221 Database Technology question paper – June 2010 / Anna University Previous Year Exam Questions / Anna University Previous Year M.E. M.Tech. Computer Science and Information Technology Question Papers

Question Paper Code : J7658 M.E. DEGREE EXAMINATION, JUNE 2010 Second Semester Computer Science and Engineering CS 9221 — DATABASE TECHNOLOGY (Common to M.E. Computer and Communications) (Regulation 2009) Time: Three hours                                                       Maximum: 100 Marks Answer ALL Questions PART A — (10 × 2 = 20 Marks) 1. What is Fragmentation? 2. What is Concurrency Control? 3. What is Persistence? 4. What is Transaction Processing? 5. What is Client/Server Model? 6. What is the difference between data warehousing and data mining? 7. Why do we need Normalization? 8. What is Integrity? 9. Give two features of Multimedia Databases. 10. What are Deductive Databases? PART B — (5 × 16 = 80 Marks) 11. (a) Explain the architecture of Distributed Databases. Or (b) Write notes on the following: (i) Query processing. (8) (ii) Transaction processing. (8) 12. (a) Discuss the Modeling and design approaches for Object Oriented Databases. Or (b) Explain the Multi-Version Locks and Recovery in Query Languages. 13. (a) Discuss in detail Data Warehousing and Data Mining. Or (b) Discuss the features of Web Databases and Mobile Databases. 14. (a) With an example, explain E-R Model in detail. Or (b) Explain the features of Temporal and Spatial-Databases in detail. 15. (a) Explain the features of Parallel Databases and Text Databases in detail. Or (b) Discuss the Rules, Knowledge Bases and Image Databases. _____________________