1. What is the difference between a PL/SQL stored procedure and a function?
2. Briefly describe the "pass-by-reference" technique of passing values between actual and formal parameters in PL/SQL.
3. Briefly describe the "pass-by-value" technique of passing values between actual and formal parameters in PL/SQL.
4. What are the three main SQL DML commands that are automatically fired up by PL/SQL triggers.
5. Which SQL DDL command is used to remove a trigger?

Answer rating: 100% (QA)

1 Difference between a PL SQL stored procedure and a function Stored Procedure A stored procedure is View the full answer