Advanced Database Management Systems - Dec 2014

Information Technology (Semester 5)

TOTAL MARKS: 80
TOTAL TIME: 3 HOURS (1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Assume data if required.
(4) Figures to the right indicate full marks. 1 (a) Explain Factless Fact Table.(5 marks) 1 (b) Compare OLTP vs OLAP.(5 marks) 1 (c) How does multilevel indexing improve the efficiency of searchingand index file?(5 marks) 1 (d) Explain different types of transparencies in distributed database.(5 marks) 2 (a) What are Triggers? Give an example.(10 marks) 2 (b) Explain Concurrency control in distributed database.(10 marks) 3 (a) Draw and Explain Data Warehouse architecture.(10 marks) 3 (b) Describe the three phases of the ARIES recovery method.(10 marks) 4 (a) Find out the data transfer cost of distributed query processing for following queries For each employee(10 marks) 4 (b) Explain with suitable example object identity, object structure and type constructors in OODBs.(10 marks) 5 (a) Explain Data loading and its types.(10 marks) 5 (b) Explain the Operations on files.(10 marks) 6 (a) Consider a data warehouse for a hospital, where there are three dimensions:
i) Doctor
ii) Patient and
iii) Time
and two measures:
i) Count and
ii) Charge,
Usin the above example describe the following OLAP operations
i) Slice
ii) Dice
iii) Rollup
iv) Drilldown
v) Pivot(10 marks) 6 (b) What are the different types of SQL injection attacks.(10 marks)