Computer Engineering Sem 4 Database Management System Question Paper PDF 2026 - Mumbai University | munotes
Loading PDF...
Questions asked in this paper
-
Q2 (a) Draw ER diagram for bank management system. Transform it into relational
-
Q2 (b) What are the types of failure in database system? Explain shadow copy and shadow paging schemes of recovery. (10)
-
Q3 (a) Explain following SQL clauses with syntax and example of each clause: IN, LIKE, ORDER BY and COUNT 10 marks
-
Q3 (b) What is normalization? Explain & 3NF with suitable example. 10 marks
-
Q4 (a) Explain two phased locking protocols in concurrency control. 10 marks
-
Q4 (b) Explain various joins in SQL with example. What is a deadlock? Explain different types of deadlock prevention (10) 10 marks
-
Q5 (b) Explain four relational algebra operations with example. 10 marks
-
Q6 Attempt the following (any two) 20 marks
- (b) Views and triggers in SQL Generalization-specialization and aggregation
Read from the scan above, so a character or two may differ. The scan is the original.
Something wrong on this page? Report it and we will check it against the scan.
Computer Engineering Sem 4 Paper Path
Use this paper as one timed CMPN Sem 4 mock, then compare Operating System, Engineering Mathematics IV, DBMS, Microprocessors, and Analysis of Algorithm papers from nearby year sets.
Step: Open this Computer Engineering Sem 4 paper in the free viewer first.
Step: Compare the May 2024 and December 2022 year sets for repeated subjects.
Step: Use the full CMPN Sem 4 folder when you need more second-year engineering practice.
Quick Help
Related Resources
Something wrong with this paper? Report it.