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 :
B.E./B.Tech.
DEGREE EXAMINATION, MAY/JUNE 2012
Sixth
Semester
Computer
Science and Engineering
CS
2029/CS 606 — ADVANCED DATABASE TECHNOLOGY
(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.
Or
(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.
Or
(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.
Or
(b) Discuss in detail
about structure and various operation of object oriented query language.
14. (a) Briefly
discuss client/server model with suitable example.
Or
(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.
Or
(b)Write notes on
(i)
Spatial database
(ii)
Query language for multimedia
(iii)
Multimedia databases
_________________________