16

17

18

19

20

a)

b)
a)

a)

b)
a)
b)
a)

02000CS208052002

Database system implementers have paid much more attention to the ACID
properties than have file-system implementers. Why might this be the case?
Explain deferred database modification with an example.
Consider a file with 450000 records . Each record size is 125 bytes and block is
1000 bytes. The primary key of the file is 10 bytes and record pointer size is 6
bytes.
1). Calculate number of index block required in case of primary indexing
2) Calculate number of index blocks required in case of multilevel indexing.
Differentiate serial and concurrent schedules. Elaborate Conflict serializability
with suitable example.
Illustrate two phase locking
Why recovery is needed in transaction processing
Illustrate heuristic query optimization with suitable example.
Write short notes on

1) Big Data

2) Biological Database

3) GIS

RK

Page 4 of 4

(6)

(4)
(10)

(6)

(4)
(5)
(5)
(10)