Advanced Database Management System - Tutorials and Notes: CS2029 Advanced Database Technology Anna University question paper - May/June 2012

Sunday, 18 May 2014

CS2029 Advanced Database Technology Anna University question paper - May/June 2012

CS2029 Advanced Database Technology question paper - May/June 2012 / Anna University Previous Year 2012 Exam Questions for Advanced Database Technology / Anna University Previous Year 2012 Computer Science and Information Technology Question Papers / CS 606 Advanced Database Technology Question Paper / CS2029 Sixth Semester Advanced Database Technology question

Question Paper Code :
Sixth Semester
Computer Science and Engineering
(Common to Seventh Semester - Information Technology)
(Regulation 2008)
Time : Three Hours                                                          Maximum : 100 marks
Answer ALL Questions
PART A – (10 X 2 = 20 marks)

1. Define database recover. Write two recovery techniques.
2. Why we need normalization?
3. Mention any four features of distributed database system.
4. What is an important two phase commit protocol?
5. Expand ODMG. When it is necessary?
6. Write any two limitation of JASMINE.
7. Define mobile database with an example.
8. List the markup languages which are suitable for web databases.
9. Write two examples of multimedia databases and multimedia structure.
10. Define spatial database.

PART B – (5 X 16 = 80 marks)

11. (a) What is query optimization? Explain any two optimization techniques in detail with suitable example.
(b) (i) Compare and contrast between BCNF and 2NF.
(ii) Draw an ER model for university which will publish examinations results of all colleges which is affiliated to it and individual results for each college.

12. (a) Explain the architecture of distributed database in detail.
(b) (i) Discuss the merits and demerits of commit protocol.
(ii) List and explain the features of DDB.

13. (a) (i) Explain the different approaches used for object oriented databases.
(ii)Write detail note on ODMG model.
(b) Discuss in detail about structure and various operation of object oriented query language.

14. (a) Briefly discuss client/server model with suitable example.
(b) (i) Compare and contrast between mobile databases and internet databases.
(ii) Explain the major role of Xml in web databases.

15. (a) (i) Explain how to identify an active and deductive databases with an example.
(ii)Write detail note data mining with its various techniques.
(b)Write notes on
(i) Spatial database
(ii) Query language for multimedia
(iii) Multimedia databases


Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents