Database Management Systems (2130703)

BE | Semester 3 
  Summer - 2018|05/23/2018
Total Marks 70

Q1 (a) Define view. Write syntax to create view. Give an example of view.

  (b) Explain tasks of DBA.

  (c) Explain disadvantages of conventional file-based system compared to Database Management System.

Q2 (a) List and explain DML statements with suitable example.

  (b) Define: Primary Key, Foreign Key and NOT NULL constraint.

  (c) Explain three level architecture of DBMS.

OR

  (c) Explain different types of outer join with example.

Q3 (a) Write a note on two phase commit protocol.

  (b) List and explain aggregation functions with suitable example.

  (c) Explain specialization and generalization concepts in ER diagram with suitable example.

OR

Q3 (a) Write a note on trigger.

  (b) Compare rollback with commit SQL commands.

  (c) Draw E-R diagram for bank management system.

Q4 (a) Write differences between shared lock and exclusive lock.

  (b) Define transaction. Explain various states of transaction with suitable diagram.

  (c) Explain steps of query processing with the help of neat diagram.

OR

Q4 (a) Describe GRANT and REVOKE commands.

  (b) Write a note on two phase locking protocol.

  (c) Explain stored procedure with proper example.

Q5 (a) What is log based recovery? Explain Immediate database modification technique for database recovery.

  (b) List and discuss ACID properties of transaction.

  (c) Write a note on conflict serializability.

OR

Q5 (a) What is deadlock of transaction? Explain wound wait technique for prevention of deadlock.

  (b) Elaborate Normalization. Explain any two normal forms with suitable example(s).

  (c) Consider following schema and write SQL for given statements.