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
B.E./B.Tech.
DEGREE EXAMINATION, NOV/DEC 2012
Sixth
Semester
Computer
Science and Engineering
CS
2029/CS 606 — ADVANCED DATABASE TECHNOLOGY
(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)
Or
(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)
Or
(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) |
Or
(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)
Or
(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.
Or
(b) (i) Explain the
issues, methodology and applications of spatial database. (8)
(ii) Write an
appropriate example explain the concepts of active databases. (8)
________________________