B.E/B.Tech
DEGREE EXAMINATION, MAY/JUNE 2012
Sixth semester
Computer
Science and Engineering
CS
606-ADVANCED DATABASE TECHNOLOGY
(Regulation
2008)
Answer ALL
questions
PART -A
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
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
published 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
note on
(i) Spatial database
(ii)Query language for multimedia
(iii)Multimedia databases