Information Technology (Semester 5)
Total marks: 80
Total time: 3 Hours
INSTRUCTIONS
(1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Draw neat diagrams wherever necessary.
1 Attempt any four questions
1.a.
Consider a suitable relation schema and perform nested query and query using group by clause
(5 marks)
00
1.b.
Explain ECA model.
(5 marks)
00
1.c.
What is view?Discuss the difference between a view and base relation
(5 marks)
00
1.d.
Define a lock and describe the types of locks used in concurrency control.
(5 marks)
00
1.e.
List differentiation between OLTP and OLAP
(5 marks)
00
2.a.
What is SQLJ used for? Describe the two types of iterators available in SQLJ.
(10 marks)
00
2.b.
Differentiate between static and dynamic SQL?Which one is more efficient?
(10 marks)
00
3.a.
Describe ARIES recovery algorithm with example.
(10 marks)
00
3.b.
Explain Indexing Technique in the database
(10 marks)
00
4.a.
Find the cost of data transfer over the network for following details. Employee table is at site 1 with 10,000 rows. Each row size is 100 bytes. Department table is at site 2 with 100 rows. Each row size is 35 bytes . Find optimum solution for data transfer if following query is executed from site 3.
Query: For each employee retrieve the emp_name and d dept_name where employee works.
(10 marks)
00
4.b.
Explain different ways of concurrency control in DDBMS.
(10 marks)
00
5
Consider a data ware house for a hospital where there are three dimensions:
1) Doctor 2) Patient 3) Time
And two measure count and charge.
Using above example perform following
i. STAR schema
ii. Snow flake schema
iii. Rollup & Drilldown operations
iv. Pivot operation
v. Slice and Dice operations
(20 marks)
00
6 Explain the following concepts with the help of example
6.a.
SQL Injection
(5 marks)
00
6.b.
Mandatory Access Control
(5 marks)
00
6.c.
Statistical Database
(5 marks)
00
6.d.
Timestamp Ordering Protocol
(5 marks)
00