CP 7202 Advanced Databases question paper – November/December 2016
|
Question Paper
Code : 17312
M.E./M.Tech.
DEGREE EXAMINATION, NOVEMBER/DECEMBER 2016
Second
Semester
Computer
Science and Engineering
CP
7202 — ADVANCED DATABASES
(Common
to M.E. Computer Science and Engineering (With specialization in Networks)
and M.Tech. Information Technology)
(Regulation
2013)
Time
: Three Hours Maximum
: 100 marks
Answer
ALL Questions
PART
A – (10 X 2 = 20 marks)
1.
What is three-tier client-server architecture?
2.
Define commit protocol. What are its types?
3.
What is meant by object persistence?
4.
Differentiate between ODL and OQL.
5.
Mention the design principles for active rules.
6.
Write the different types of queries used in spatial database.
7.
Mention the significance of handoff management.
8.
How is mining different from searching?
9.
Can you store XML in databases? Justify your answer.
10.
List some of the cloud data models.
PART
B – (5 X 13 = 65 marks)
Or
(ii)
What is distributed query processing? Explain in detail with an example. (6)
12.
(a) (i) Describe about object identity, object structure and type
constructors in Object oriented databases. (6)
(ii)
Distinguish between object oriented and object relational databases. (7)
Or
(b)
Explain the components of ODMG model. (13)
13.
(a) Describe the syntax and semantics of Active databases explain how the
active rules are specified in Oracle. (13)
Or
(b)
(i) How are recursive queries specified in SQL? Explain. (8)
(ii)
Describe about Temporal databases. (5)
14.
(a) Explain about the mobile transaction models. (13)
Or
(b)
Explain the various data classification methods for data mining. (13)
15.
(a) Write a note on:
(i)
Native XML database. (7)
(ii)
Web databases. (6)
Or
(b)
Describe cloud storage architecture with neat diagram. (13)
PART
C – (1 X 15 = 15 marks)
16.
(a) How is concurrency control achieved in distributed databases? Justify your
answer with an example.
Or
(b)
Mention the problems of location-dependent data distribution. How does it
affect the data integrity and data consistency? Explain your answer.
________________________
|
CS 921 - Database Technology Anna University ME/MTech question paper
CP 7202 - Advanced Databases Anna University ME/MTech Question paper
Anna University Exam Questions with Answers