CP 7202 Advanced Databases question paper – May/June 2014
CP 7202 Advanced Databases question paper – May/June 2014 / Anna University Previous Year Exam Questions / Anna University Previous Year M.E. M.Tech. Computer Science and Information Technology Question Papers / Previous Year Anna University Exam Questions with Answers
Question
Paper Code : 63294
M.E./M.Tech. DEGREE EXAMINATION, MAY/JUNE
2014
Second Semester
Computer Science and Engineering
CP 7202 — ADVANCED DATABASES
(Common to 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 × 2 =
20 Marks)
1.
What is the advantage of parallelism?
2.
What is the difference between parallel system and distributed system?
3.
Give examples for object relational databases.
4.
How is object database differentiated from relational database?
5.
What is meant by spatial database?
6.
Define Semantics
7.
What is mobility?
8.
How is mining different from searching?
9.
What is structured data?
10.
What is XML Schema?
PART B — (5
× 16 = 80 Marks)
11.
(a) Define Parallel databases. Explain the inter and intra query parallelism.
(16)
Or
(b)
How are the transactions are handled in distributed database? Explain. (16)
12.
(a) What are the object relational features in SQL? Explain. (16)
Or
(b)
(i) Write in details about ODMG model with ODL and OQL
(ii)
Distinguish object oriented and object relational databases
13.
(a) What are spatial data structures? And explain any two (16)
Or
(b)
Discuss the design principles for Active rules. (16)
14.
(a) Write detailed notes on Concurrency control in mobile database. (16)
Or
(b)
Explain any two retrieval models used in Information Retrieval. (16)
15.
(a) Give details about approaches used to store XML documents in database.
(16)
Or
(b)
Describe Cloud storage architecture and Big-data storage analysis with
suitable example. (16)
_____________________________
|