STUPIDSID
1 (a)
Draw an E-R diagram for Banking enterprise.
7 M
1 (b)
What is Relational Algebra? Enlist and Explain the fundamental operation of
relational algebra.
7 M
2 (a)
What is the difference between Database user and Database administrator?
Explain various functions of Database Administrator?
7 M
2 (b)
Explain various operations in DDL, DML and DCL SQL languages.
7 M
2 (c)
Explain Inner Join and Outer Join with SQL queries.
7 M
3 (a)
Explain wait-die and wound-wait for deadlock prevention.
7 M
3 (b)
Explain deferred database modification for log based recovery.
7 M
3 (c)
Explain three type of actions to be taken for recovery from deadlock.
7 M
3 (d)
What is serializability? Explain view serializability with example
7 M
4 (a)
What is decomposition? Explain Lossy and Non-loss decomposition with
suitable example.
7 M
4 (b)
Explain the steps in query processing? How the cost of query is measured?
7 M
4 (c)
What is Normalization? Explain Normalization process for 1NF, 2NF and 3NF with example.
7 M
4 (d)
What is query optimization? Explain how to optimize nested sub queries.
7 M
5 (a)
What is aggregate function? Explain any five aggregate functions with example.
7 M
5 (b)
What is difference between SQL and PL/SQL? Write a PL/SQL block to
determine the given number is odd or even
7 M
5 (c)
Explain Having, Group by and order by clause with example.
7 M
5 (d)
What is non-procedural Language? Write a PL/SQL block to print the square of
number from 1 to 10 (Inclusive).
7 M
More question papers from Database Management Systems