241204 Database Technology question paper - June 2011 / Anna University Previous Year Exam Questions / Anna University Previous Year M.E. M.Tech. Computer Science and Information Technology Question Papers
|
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
Computer Science and Engineering
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 database? 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 multi-valued 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 the 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 in 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 in heritance in the object oriented
model with an example. (8)
Or
(b)
Discuss in detail about the concurrency control in object oriented databases.
(16)
13.
(a) (i) Explain the various client/server architectures commonly used in the
database environment. (8)
(ii)
Explain web databases in detail. (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 the query optimization. (16)
Or
(b)
Suppose that a city transportation department would like to perform data
analysis on highway traffic for the planning the highway construction based
on the city traffic data collected at different hours every day. Design a
spatial database 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)
_____________________________
|