CS9221 DATABASE TECHNOLOGY Question Paper

Question Paper Code : 31283
M.E./M.Tech. DEGREE EXAMINATION, JUNE 2011.
Common to M.E. Computer Science and Engineering/ M.E. Computer
and Communications
Second Semester

241204 — DATABASE TECHNOLOGY
(Regulation 2010)

Time : Three hours Maximum : 100 marks

Answer ALL questions.

PART A — (10 ´ 2 = 20 marks)
1. State the advantages of distributed databases.
2. List the types of data fragmentation? Give reasons for fragmenting a relation
in the distributed system.
3. What is persistence in object oriented data base? Why it is important?
4. How does the concept of an object in the object-oriented model differ from the
concept of an entity in the entity-relationship model?
5. Compare and contrast data warehouse and operational database.
6. Specify the different categories of data available in the Mobile databases.
7. How do spatial databases differ from regular databases?
8. What is multivalued dependency? Specify the procedure for eliminating it from
a relation.
9. Mention the applications of deductive databases.
10. What are the different types of multimedia sources?



PART B — (5 ´ 16 = 80 marks)

11. (a) Explain the issues that are addressed for a distributed database design.
(16)
Or
(b) (i) During the transaction execution, it passes through several states,
until it finally commits or aborts. List all possible sequences of
states through which a transaction may pass. Explain why each
state transition may occur. (6)
(ii) Consider the following undo/redo log with check pointing (CKPT).
The third and fourth values in entries that have 4 values are the
old and the new value, respectively.
<START, T1>
<T1, A, 4, 5>
<START,T2>
<T2, B, 9, 10>
<START CKPT (T1; T2)>
<COMMIT T2>
<START T3)>
<T3, C, 14, 15>
<END CKPT>
<COMMIT T3>
<COMMIT T1>
Suppose that there is a crash, and the last log entry to appear on
disk is <T2, B, 9, 10>.That is; only the first 4 log entries shown
above actually appear in the log. The remaining 7 entries are never
recorded on the log. Describe the actions of the recovery manager,
including changes to both the disk and log. Describe the actions at
recovery time. Specify the actions happened in the disk and log for
both the cases. (10)
12. (a) (i) What are main features of object oriented database? How it is
advantageous over RDBMS? (8)
(ii) Compare inheritance in the Extended ER model to inheritance in
the Object Oriented model with an example. (8)
Or
(b) Discuss in detail about the concurrency control in object oriented
databases. (16)
2120 2120 2120 2120
3 31283
13. (a) (i) Explain the various client/server architectures commonly used in
the database environment. (8)
(ii) Explain web databases in details. (8)
Or
(b) (i) What is data mining? How does data mining technology relate to
data warehousing technology? (8)
(ii) Describe the steps of building a data warehouse. (8)
14. (a) What is meant by the term heuristic optimization? Discuss the main
heuristics that are applied during query optimization. (16)
Or
(b) Suppose that a city transportation department would like to perform
data analysis on highway traffic for the planning of highway construction
based on the city traffic data collected at different hours every day.
Design a spatial data base for the given scenario ,to store the highway
traffic information such as average and peak time traffic flow by
highway, by time of day, and by weekdays, and the traffic situation
when a major accident occurs. (16)
15. (a) Discuss the features of active databases and deductive databases. (16)
Or
(b) (i) What are parallel databases? What are its benefits? (8)
(ii) Explain multimedia databases in detail. (8)
———————

Question Paper Code: J7658

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.
——————

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.

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
————––––——