Saturday, May 17, 2014

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

CS2029 Advanced Database Technology question paper - Nov/Dec 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

Question Paper Code : 11253
Sixth Semester
Computer Science and Engineering
(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 cascading rollback.
2. Mention any two ways of tuning the query processing in relational databases.
3. Give a simple distributed access plan for a scenario of your choice.
4. With proper illustration define mixed fragmentation.
5. Illustrate the differences between the type constructors – bag and list.
6. ‘Versioning is important in Object Oriented Databases’ – Justify.
7. Write a trigger to compare an employee’s salary with that of her supervisor. (Note: Assume employee schema as: Emp (Name, Eno, Sal, Dno, Supervisor_Eno).
8. What issues are to be considered regarding the data management in mobile databases?
9. Brief on the data structures used for the multimedia databases.
10. What are the different types of specification used in deductive databases?

PART B – (5 X 16 = 80 marks)

11. (a) (i) Explain the impact of indexes in the databases. Discuss on the re-designing of the indexes for database tuning. (10)
(ii) Discuss in detail about any three recovery techniques. (6)
(b) (i) Consider a scenario where you are asked to store information about Department complaints holding the following details:
Dept_No, Dept_Name, Location, Mgr_Name, Mgr_ID_No, Tel_Extn, Cust_No, Cust_Name, Date_of_Complaint, Nature_of_Complaint.
Also, assume that the Dept_No, and Cust_No are all needed to uniquely identify the date and nature of the complaint about the department. Identify the dependencies of the given structure and convert that as a normalized structure. (12)
(ii) Explain any one Timestamp methods for concurrency control. (4)

12. (a) (i) List possible types of failure in a distributed system. For each possible failure, explain how 2PC ensures transaction atomicity despite the failure. (10)
(ii) Explain how I/O parallelism is attained in a parallel database environment. (6)
(b) (i) Describe in detail about the concurrency control in distributed databases. (8)
(ii) Explain the Intra-operation parallelism with respect to Join and Sort operations. (8)

13. (a) (i) Compare inheritance in the EER model to inheritance in the OO model. (8)
(ii) Give an equivalent OODB schema in ODL for the RDB schema of Fig. 13. (a).(ii).
Fig. 13. (a).(ii)
(b) (i) List the features, advantages and disadvantages of OODBMS. (8)
(ii) Express the RDB schema of Fig. 13. (a).(ii) in POSTGRES. (8)

14. (a) (i) Explain the architecture and construction of data warehouse. (8)
(ii) Is data mining a threat to privacy and data security? Justify. (8)
(b) (i) Narrate in detail the automatic web documents classification. (8)
(ii) Explain the architecture of mobile database with neat sketch. (8)

15. (a) (i) Explain in detail how the video sources are represented in multimedia database. (8)
(ii) How the rules are interpreted in deductive databases? Explain with examples.
(b) (i) Explain the issues, methodology and applications of spatial database. (8)
(ii) Write an appropriate example explain the concepts of active databases. (8)



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