STUPIDSID
1 (a)
Explain Factless Fact Table.
5 M
1 (b)
Compare OLTP vs OLAP.
5 M
1 (c)
How does multilevel indexing improve the efficiency of searchingand index file?
5 M
1 (d)
Explain different types of transparencies in distributed database.
5 M
2 (a)
What are Triggers? Give an example.
10 M
2 (b)
Explain Concurrency control in distributed database.
10 M
3 (a)
Draw and Explain Data Warehouse architecture.
10 M
3 (b)
Describe the three phases of the ARIES recovery method.
10 M
4 (a)
Find out the data transfer cost of distributed query processing for following queries "For each employee, retrieve the employee name & name of the department for which the employee works."
Site1: Employee
| Fname | Minit | Laname | SSn | Bdate | Address | Sex | Salary | SSSn | Dno |
10000 records each record is 100 bytes long.
SSn field is 9 bytes, Fname filed is 15 bytes, Dn field is 4 bytes, Lname is 15 bytes.
Site 2: Department
| Dname | Dnumber | Mgrssn | Mgrstartdate |
100 records each record is 35 bytes long, Dnuber field is 4 bytes, Dname field is 10 bytes, Mgrssn field is 9 bytes. Query is submitted to result site 3. Consider different strategies for executing this query and find which strategy is best using natural join and semijoin.
10 M
4 (b)
Explain with suitable example object identity, object structure and type constructors in OODBs.
10 M
5 (a)
Explain Data loading and its types.
10 M
5 (b)
Explain the Operations on files.
10 M
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
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 M
6 (b)
What are the different types of SQL injection attacks.
10 M
More question papers from Advanced Database Management Systems