1.a. Explain concept of a View in SQL

1.b. What is the role of Metadata in data warehouse

1.c. Use Figure-1 and write SQL query to retrieve the name of each employee who has a dependent with the same first name and is the name sex as the employee

1.d. What is Write-Ahead Logging and when is it used?

2.a. Explain the ARIES Recovery Algorithm with suitable example.

2.b. Explain Star Schema. Draw Star Schema for Supermarket.

3.a. Explain Multilevel Indexes with suitable example

3.b. Explain Data Warehouse architecture in detail.

4.a. Explain OLAP Operations in Multidimensional Data Model with suitable example.

4.b. ) Explain Query Processing and Optimization in Distributed Databases.

5.a. Explain the concept, Immediate Data Extraction and Deferred Data Extraction in data warehouse with suitable example.

5.b. List and explain Data Fragmentation in distributed databases.

6.a. There are two levels for assigning privileges to use the database system: i)The account level and ii) The relation/table level. Give example of each considering the database shown in Figure-1 .

6.b. Write short note on "SQL injection".

6.c. What is multiple granularity locking> Under what circumstances is it used?

6.d. Suppose we want to check whenever an employee's salary is greater than the salary of his or her direct supervisor is the COMPANY database shown in Figure-1 . Several events can trigger this rule : inserting a new employee record, changing an employee's salary, or changing an employee's supervisor.

Figure-1