CS2029/CS606 Advanced Database Technology question paper - Nov/Dec 2011 / 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
P275
B.E./B.Tech.
DEGREE EXAMINATION, NOV/DEC 2011
Regulations
2008
Sixth
Semester
CS
606 — ADVANCED DATABASE TECHNOLOGY
Computer
Science and Engineering
(Common
to Information Technology for Seventh Semester)
Time
: Three Hours Maximum
: 100 marks
Answer
ALL Questions
PART
A – (10 X 2 = 20 marks)
1. Define schema
tuning and index tuning.
2. Why we need
normalization in DB?
3. What is inter
query parallelism and intra query parallelism?
4. What is meant by Fragmentation
and Replication in Distributed DB?
5. What are the goals
of OODB?
6. What are the
methods for creating persistent objects?
7. How the
information can be stored and retrieved from mobile database?
8. List out the
relationship between data warehouse and data mining.
9. Mention the types of
spatial queries.
10. Define active
database.
PART
B – (5 X 16 = 80 marks)
11. (a) Define
Normalization and Describe first, second, third and BCNF normal forms with
examples. (16)
Or
(b) (i) Draw an E-R
diagram for a Railway Reservation System. (6)
(ii) Explain in
detail about two-phase locking protocol. (10)
12. (a) (i) Explain
what is meant by location, fragmentation and replication transparency and
indicate how these are achieved in a distributed database. (8)
(ii) Briefly explain
distributed query processing. (8)
Or
(b) Explain about
concurrency control in distributed databases. (16)
13. (a) Explain in
detail about transaction management, storage and linking procedure of POSTGRES.
(16)
Or
(b) Describe
multi-version locks and recovery of Object Oriented Databases. (16)
14. (a) Explain in
detail about data warehouse architecture and its implementation. (16)
Or
(b) (i) Explain about
web database. (8)
(ii) Give XML
representation of bank management system and also explain about Document Type Definition
and XML schema. (8)
15. (a) Explain about
the following:
(i) Deductive DB (8)
(ii) Spatial DB (8)
Or
(b) (i) How can you
construct a multimedia database? (6)
(ii) Describe about
multimedia query languages. (10)
________________________