Saturday, May 17, 2014

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

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

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

1. Write an SQL query to retrieve employee name and Id from a table employee.
2. What is Concurrency Control?
3. Differentiate intra query parallelism from inter query parallelism.
4. Differentiate distributed database and normal database.
5. How transaction is performed in Object oriented database?
6. What is versioning in terms of object oriented database?
7. List the advantages of XML over HTML.
8. Specify the advantages of Data warehousing.
9. How spatial databases are more helpful than active database?
10. What is deductive database?

PART B – (5 X 16 = 80 marks)

11. (a) (i) Illustrate and discuss the steps involved in processing a query with neat diagram.                                                                                                         (12)
(ii) Discuss briefly on database tuning.                                                          (4)
(b) Explain the following with an example in relational model
(i) Transaction Processing
(ii) Query Optimization                                                                                 (16)

12. (a) (i) Explain with a neat diagram the architecture of distributed databases also mention its uses.                                                                                        (8)
(ii) Discuss the ACID properties of a transaction with relevant example.                   (8)
(b) (i) Explain the Distributed transaction Processing with suitable example.   (10)
(ii) Explain the role of recovery subsystem in a distributed environment.                  (6)

13. (a) (i) Explain the object oriented database and its approaches.               (8)
(ii) Explain the component of the ODMG model with example.                        (8)
(b) (i) Discuss the transaction states in object oriented databases.                          (8)
(ii) What is POSTGRES? Explain it in detail.                                                     (8)

14. (a) (i) How XML are processed and stored in web database? Explain with an example.                                                                                                   (8)
(ii) Explain the process of mobile database and its advantages over other database.                                                                                                                    (8)
(b) (i) Explain the steps involved in constructing a data warehouse.                (8)
(ii) Explain about the decision trees in the process of data mining.                          (8)

15. (a) (i) Describe the active and deductive database and compare with each other.                                                                                                                            (8)
(ii) Explain the role and use of multimedia database for current technologies.          (8)
(b) Elaborate the following with an example.                                                 (16)
(i) Spatial databases
(ii) Multimedia query with complex types.


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