STUPIDSID
1(a)
What is referential integrity? Explain with suitable example.
5 M
1(b)
Explain in short Object Query Language (OQL).
5 M
1(c)
Explain in short dynamic SQL.
5 M
1(d)
List the different types of transparencies in distributed databases and explain any one in detail.
5 M
2(a)
Differentiate between
i) Data Warehouse Modeling Vs Operational Database Modeling.
ii) OLTP vs OLAP
i) Data Warehouse Modeling Vs Operational Database Modeling.
ii) OLTP vs OLAP
5 M
2(b)
Explain Dynamic Multilevel Indexes Using B-Trees or B+ - Trees.
10 M
3(a)
What are the different types of SQL injection attacks? What risks are associated with it? Explain any one attack in detail.
10 M
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.
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 M
4(a)
Explain with suitable example object identity, object structure and type construction in OODB's.
10 M
4(b)
Explain with suitable example 'Star Schema:.
10 M
5(a)
Explain ECA model with suitable example.
10 M
5(b)
Explain Discretionary Access Control based on Granting and Revoking Privileges.
10 M
6(a)
Explain in short the concurrency control in distributed databases.
10 M
6(b)
Explain ETL phase in creating a data warehouse.
10 M
More question papers from Advanced Database Management Systems