PL/SQL Assignment Questions PDF
Document Details
Uploaded by DazzlingKremlin2019
Tags
Summary
This document contains assignment questions covering various topics in PL/SQL programming, including exceptions, functions, transactions, associative arrays, conditional statements, varrays, cursors, and database triggers. The questions are categorized into Mid-I and Mid-II, focusing on different aspects of the subject.
Full Transcript
**Mid-I Assignment questions** 1. Give a brief summary on exceptions. 2. Explain the concept of functions in PL/SQL. 3. Write short notes on transaction scope. 4. Write a PL/SQL program to demonstrate exceptions. 5. Give a brief description on associative arrays. 6. Explain conditional s...
**Mid-I Assignment questions** 1. Give a brief summary on exceptions. 2. Explain the concept of functions in PL/SQL. 3. Write short notes on transaction scope. 4. Write a PL/SQL program to demonstrate exceptions. 5. Give a brief description on associative arrays. 6. Explain conditional statements in PL/SQL. 7. How to declare Varray collection type in PL/SQL? 8. Given the table EMPLOYEE (Empno, Name, Salary, Designation, Dept. ID) Write a cursor to select the five highest paid employees from the table. **Mid-II Assignment questions** 9. Describe mixed notation and exclusionary notations in PL/SQL. 10. Differentiate between functions and procedures. 11. Explain the following. a) Calling subroutines. b) Pass-by-value procedures. 12. Compare various types of validation methods in PL/SQL. 13. What are definer and invoker rights in database? Explain. 14. How to manage packages in the database catalog? Explain. 15. Briefly explain system and database event triggers. 16. Explain the following. a) Database trigger architecture. b) Compound triggers.
