[Total Time: 3 hrs.]
[Total Marks: 80]
Please check whether you have got the right question paper.
N.B.: 1) Q. 1 is compulsory
2) Solve any three form reaming questions.
3) Draw neat diagrams wherever necessary.
____________________________________________________________________________________________________________________________
Q. 1) a) Explain types of users of the database system with suitable examples & responsibilities of DBA. (10M)
b) Explain extended ER features. (10M)
Q. 2) a) Explain types of join with suitable examples. (10M)
b) Explain constraints in SQL. (10M)
Q. 3) a) Explain relational algebra operators. (10M)
b) What is Log? Explain Log-based recovery. (10M)
Q. 4) a) What is 2PL. Explain 2PL (2-phase) Locking protocol with its types. (10M)
b) What is a trigger? Write syntax an example. (10M)
Q. 5) a) Explain view serializability with suitable examples. (10M)
b) What is Normalization? Explain 1NF, 2NF, and 3NF with suitable is examples. (10M)
Q. 6) Write a note on (Any two) (20M)
a) Timestamp Based Protocol
b) Transaction state diagram
c) Functional dependency in dbms.
____________________________________________________________________________________________________________________________