CP7202 - Advanced Databases November December 2016 Anna University Question

CP 7202 Advanced Databases question paper – November/December 2016 

Question Paper Code : 17312 M.E./M.Tech. DEGREE EXAMINATION, NOVEMBER/DECEMBER 2016 Second Semester Computer Science and Engineering CP 7202 — ADVANCED DATABASES (Common to M.E. Computer Science and Engineering (With specialization in Networks) and M.Tech. Information Technology) (Regulation 2013) Time : Three Hours                                                          Maximum : 100 marks Answer ALL Questions PART A – (10 X 2 = 20 marks) 1. What is three-tier client-server architecture? 2. Define commit protocol. What are its types? 3. What is meant by object persistence? 4. Differentiate between ODL and OQL. 5. Mention the design principles for active rules. 6. Write the different types of queries used in spatial database. 7. Mention the significance of handoff management. 8. How is mining different from searching? 9. Can you store XML in databases? Justify your answer. 10. List some of the cloud data models. PART B – (5 X 13 = 65 marks) 11. (a) Explain inter and intra query parallelism in parallel databases. (13) Or (b) (i) Explain two-phase commit protocol used in distributed databases. (7) (ii) What is distributed query processing? Explain in detail with an example. (6) 12. (a) (i) Describe about object identity, object structure and type constructors in Object oriented databases. (6) (ii) Distinguish between object oriented and object relational databases. (7) Or (b) Explain the components of ODMG model. (13) 13. (a) Describe the syntax and semantics of Active databases explain how the active rules are specified in Oracle. (13) Or (b) (i) How are recursive queries specified in SQL? Explain. (8) (ii) Describe about Temporal databases. (5) 14. (a) Explain about the mobile transaction models. (13) Or (b) Explain the various data classification methods for data mining. (13) 15. (a) Write a note on: (i) Native XML database. (7) (ii) Web databases. (6) Or (b) Describe cloud storage architecture with neat diagram. (13) PART C – (1 X 15 = 15 marks) 16. (a) How is concurrency control achieved in distributed databases? Justify your answer with an example. Or (b) Mention the problems of location-dependent data distribution. How does it affect the data integrity and data consistency? Explain your answer. ________________________

Go to ME/MTech Anna University Previous Year Questions page

CS 9221 - Database Technology Anna University ME/MTech Question paper
CS 921 - Database Technology Anna University ME/MTech question paper
CP 7202 - Advanced Databases Anna University ME/MTech Question paper
Anna University Exam Questions with Answers