STUPIDSID
1 (a)
Explain disadvantage of conventional file-based system compared to Database management system.
7 M
1 (b)
Explain Entity Relationship model with example.
7 M
2 (a)
Write a short note on Relational algebra.
7 M
2 (b)
What are integrity constraints? Explain various type of integrity constraints with suitable example.
7 M
2 (c)
Explain three level architecture of DBMS.
7 M
3 (a)
What is normalization ? Why normalization process is needed? Explain 1 NF, 2NF and 3 NF with example.
7 M
3 (b)
What is deadlock ? Explain deadlock detection and prevention policies.
7 M
3 (c)
Explain conflict serializability and view serializability.
7 M
3 (d)
What is decomposition? Why is it required? Explain the difference between lossy decomposition and non-loss decomposition with example.
7 M
4 (a)
Write short note on query processing.
7 M
4 (b)
Explain log-based recovery and shadow paging technique.
7 M
4 (c)
Explain different types of outer join with example.
7 M
4 (d)
Explain time stamp based protocols.
7 M
5 (a)
Write A PL/SQL block to print the sum of Numbers from 1 to 20.
7 M
5 (b)
Explain DDL, DML and DCL syntaxes with example.
7 M
5 (c)
Write A PL/SQL block to print the given number is Odd or Even.
7 M
5 (d)
Explain Aggregate, Date and String function with example.
7 M
More question papers from Database Management System