munotes®

Engineering B.E. (Computer Engineering) Sem 5 Database Management System Dec 2019 Question Paper - Mumbai University | munotes

Database Management System Question Paper, Dec 2019.pdf
CMPN · 235 KB · 1 May 2025

Loading PDF...

Older exam May 2019 Semester-end · Database Management System →
Newer exam None yet: this is the latest New papers land after each exam season.

Questions asked in this paper

  • Please check whether you have got the right question paper
  1. Q2 Solve any three from reaming questions
  2. Q1 a) Explain types of users of the database system with suitable example & 10 marks
    • b) Explain extended ER features. 10
  3. Q2 a) Explain types of join with suitable example. 10 marks
    • b) Explain constraints in SQL. 10
  4. Q3 Explain relational algebra operators. 10 marks
    • b) What is Log. Explain Log based recovery. 10
  5. Q4 a) What is 2PL. Explain 2PL (2- phase) Locking protocol with its types. 10 marks
    • b) What is trigger? Write syntax and example. 10
    • a) Explain view serializability with suitable examples. 10
    • b) What is Normalization? Explain 1NF, 2NF and 3NF with suitable is example. 10
  6. Q6 Write note on (Any two) 20 marks
    • b) Transaction state diagram
    • c) Functional dependency in dbms

Read from the scan above, so a character or two may differ. The scan is the original.

Issue

Something wrong on this page? Report it and we will check it against the scan.

Quick Help

No. The full paper opens straight away, with no login and nothing to pay.

Something wrong with this paper? Report it.

Connected Papers
Engineering / B.E. (Computer Engineering) · 250 papers
Browse all →
Questions? Email contact@munotes.in
Done!
Done!