Question
Paper Code: 97730
M.E.
DEGREE EXAMINATION, NOVEMBER/DECEMBER 2010
Second Semester
Computer Science and Engineering
CS 9221 — DATABASE TECHNOLOGY
(Common to M.E. Computer and
Communication)
(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.
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
Reg.
No. :
M.E. DEGREE EXAMINATION, JUNE 2010
Second
Semester
Computer
Science and Engineering
CS9221
— DATABASE TECHNOLOGY
(Common
to M.E. Computer and Communication)
(Regulation
2009)
Time
: Three hours Maximum
: 100 Marks
Answer
ALL Questions
PART
A — (10×2 = 20 Marks)
1. What is Fragmentation?
2. What is Concurrency Control?
3. What is Persistence?
4. What is Transaction Processing?
5. What is Client/Server Model?
6. What is the difference between data warehousing and data
mining?
7. Why do we need Normalization?
8. What is Integrity?
9. Give two features of Multimedia Databases.
10. What are Deductive Databases?
PART
B — (5 × 16 = 80 Marks)
11. (a) Explain the architecture of Distributed Databases.
Or
(b) Write notes on the following:
(i) Query processing. (8)
(ii) Transaction processing. (8)
12. (a) Discuss the Modelling and design approaches for
Object Oriented Databases.
Or
(b) Explain the Multi-Version Locks and Recovery in Query
Languages.
13. (a) Discuss in detail Data Warehousing and Data Mining.
Or
(b) Discuss the features of Web Databases and Mobile
Databases.
14. (a) With an example, explain E-R Model in detail.
Or
(b) Explain the features of Temporal and Spatial-Databases
in detail.
15. (a) Explain the features of Parallel Databases and Text
Databases in detail.
Or
(b) Discuss the Rules, Knowledge Bases and Image Databases.
No comments:
Post a Comment