CS 9221 / 241204 Database Technology question paper – Nov-Dec 2010 / Anna University Previous Year Exam Questions / Anna University Previous Year M.E. M.Tech. Computer Science and Information Technology Question Papers
Question
Paper Code : 97730
M.E. DEGREE EXAMINATION, NOV/DEC 2010
Second Semester
Computer Science and Engineering
CS 9221 — DATABASE TECHNOLOGY
(Common to M.E. Computer and
Communications)
(Regulation 2009)
Time: Three hours Maximum:
100 Marks
Answer ALL Questions
PART A — (10 × 2 =
20 Marks)
1.
What is query processing?
2.
Define concurrency control.
3.
What is persistence?
4.
Give two features of object oriented databases.
5.
What is Data warehousing?
6.
List any two features of web databases.
7.
What is Normalization?
8.
Define Integrity.
9.
What are Deductive Databases?
10.
Mention two features of parallel Databases.
PART B — (5
× 16 = 80 Marks)
11.
(a) Compare Distributed databases and conventional databases.
Or
(b)
Discuss in detail the architecture of distributed databases.
12.
(a) Explain the multi–version locks and recovery in query languages.
Or
(b)
Describe modeling and design approaches for object oriented databases.
13.
(a) Explain the features of Data warehousing and data mining.
Or
(b)
Discuss client/server model and mobile databases.
14.
(a) Give the features of Temporal and spatial databases.
Or
(b)
(i) Explain E–R model with an example. (8)
(ii)
Discuss the optimization and research issues. (8)
15.
(a) Discuss multimedia databases in detail.
Or
(b)
Explain the features of active and deductive databases in detail
___________________
|