Saturday, May 17, 2014

CS2029 Advanced Database Technology Anna University question paper - Nov/Dec 2011

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

Regulations 2008
Sixth Semester
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)
(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)
(b) Explain about concurrency control in distributed databases.                     (16)

13. (a) Explain in detail about transaction management, storage and linking procedure of POSTGRES.                                                                                                 (16)
(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)
(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)
(b) (i) How can you construct a multimedia database?                                   (6)
(ii) Describe about multimedia query languages.                                            (10)


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

data recovery