CS 9221 / CS 921 Database Technology question paper – Nov/Dec 2013

CS 9221 / CS 921 Database Technology question paper – Nov/Dec 2013 / Anna University Previous Year Exam Questions for ME CSE / Anna University Previous Year M.E. M.Tech. Computer Science and Information Technology Question Papers / CS 9221 / CS 921 Database Technology question paper – Nov/Dec 2013 for ME Computer and Communication Engineering

Question Paper Code : 81328 M.E. DEGREE EXAMINATION, NOVEMBER/DECEMBER 2013 Second Semester Computer Science and Engineering CS 9221 / CS 921 — DATABASE TECHNOLOGY (Common to M.E. Computer and Communication) (Regulation 2009) Time: Three hours                                                       Maximum: 100 Marks Answer ALL Questions PART A — (10 × 2 = 20 Marks) 1. What is database? 2. Define concurrency control. 3. Mention about the object oriented databases. 4. What is a query language? 5. Define server model. 6. What is meant by web databases? 7. Mention about ER model. 8. What are spatial databases? 9. Define knowledge bases. 10. What is meant by Text database? PART B — (5 × 16 = 80 Marks) 11. (a) (i) Describe in detail about the distributed databases and conventional databases. (6) (ii) Illustrate the architecture of distributed databases. (10) Or (b) Briefly explain about the query processing and transaction processing in distributed databases. (16) 12. (a) Discuss in detail about the modeling and design of the object oriented databases. (16) Or (b) (i) Explain about multi version locks. (8) (ii) Explain OQL with suitable examples. (8) 13. (a) (i) Illustrate the architecture of Data warehousing. (10) (ii) List the applications of data mining. (6) Or (b) (i) Discuss in detail about the web databases. (8) (ii) Illustrate the mobile transaction models. (8) 14. (a) (i) Explain in detail about the normalization in databases. (10) (ii) List the factors to be considered to tune the database. (6) Or (b) (i) Describe in detail about the query optimization. (8) (ii) Write short notes on spatial databases. (8) 15. (a) Briefly discuss about Active and Deductive databases. (16) Or (b)  (i) Describe the architecture of multimedia databases. (10) (ii) Give the different architectural models of parallel databases. (6) _____________________________

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) ____________________