Advanced Database Management Systems - May 2016
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) What is referential integrity? Explain with suitable example.(5 marks) 1(b) Explain in short Object Query Language (OQL).(5 marks) 1(c) Explain in short dynamic SQL.(5 marks) 1(d) List the different types of transparencies in distributed databases and explain any one in detail.(5 marks) 2(a) Differentiate between
i) Data Warehouse Modeling Vs Operational Database Modeling.
ii) OLTP vs OLAP(5 marks) 2(b) Explain Dynamic Multilevel Indexes Using B-Trees or B+ - Trees.(10 marks) 3(a) What are the different types of SQL injection attacks? What risks are associated with it? Explain any one attack in detail.(10 marks) 3(b) Consider the following database that has to be distributed:
PROJ (PNO , PNAME, BUDGET)
PAY (Title, SALARY)
EMP (ENO, ENAME ,TITLE)
ASG (ENO,PNO, RESPONSIBILITY, DURATION)
1. Show 2 examples of horizontal fragmentation.
2. Show 1 example of vertical fragmentation.(10 marks) 4(a) Explain with suitable example object identity, object structure and type construction in OODB's.(10 marks) 4(b) Explain with suitable example 'Star Schema:.(10 marks) 5(a) Explain ECA model with suitable example.(10 marks) 5(b) Explain Discretionary Access Control based on Granting and Revoking Privileges.(10 marks) 6(a) Explain in short the concurrency control in distributed databases.(10 marks) 6(b) Explain ETL phase in creating a data warehouse.(10 marks)