• Attempt any five questions.
• All questions carry equal marks.
Draw and explain the detailed system architecture of DBMS. alt=''
How to represent generalization, specialization and aggregation using ER Diagrams? Explain with suitable ER diagram. alt=''
How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?
Explain the importance of Null values in Relational Model.
Explain in detail about various key constraints used in database system.
Discuss the mechanism of attribute relationship inheritance. How is it useful?
Discuss in detail the operators SELECT, PROJECT and UNION with suitable examples.
Give a brief note on Query optimization.
Explain the role of functional dependencies in normalization with suitable examples.
Explain about Boyce Codd normal form with an example.
Explain Timestamping protocols for concurrency control.
What is 2-phase locking protocol? Compare 2PL with Strict 2PL protocol.
What is Transaction? Discuss about transaction recovery techniques.
Explain briefly:
i) Distributive Databases
ii) Triggers
iii) Join operations
What is Cursor Management? Explain nested and parameterized cursors.
Write short notes :
i) Oracle Exception Handling Mechanism
ii) Branching and looping Constructs in ANSI SQL.
