Define database programming. Describe the differences between procedural and non-procedural access to a database. [1+4]
What is a subquery? Explain the use of GROUP BY and HAVING clauses in SQL. [1+4]
Explain the concept of parameter modes (IN, OUT, IN OUT) in PL/SQL with examples. [5]
Define trigger. Write the syntax to create a row-level trigger in PL/SQL. [1+4]
Write a PL/SQL block using an explicit cursor to display all employee names from the Employee table. [5]
What are constants in PL/SQL? Give syntax and an example. [5]
Differentiate between anonymous blocks and named blocks in PL/SQL. [5]
Attempt any TWO questions
[2x10=20]Explain stored procedure. Explain views in SQL, their creation, modification, and deletion with examples. [3+7]
Explain the structure of a PL/SQL block with an example. Explain exception handling in PL/SQL with examples of predefined and user-defined exceptions. [5+5]
What are cursor parameters? Give an example. Describe the types of iterative control structures available in PL/SQL with examples. [4+6]