PL/SQL Concepts Quiz

What is the benefit of using a FOR loop with a cursor in PL/SQL?

• Requires manual fetch and close

• Better for DDL statements

• Automatically opens, fetches, and closes the cursor

• Supports dynamic SQL

Why use a REF cursor in PL/SQL?

• To return static result sets only

• To return dynamic result sets from queries

• For use with DDL only

• To optimize exception handling

Which statement is true about stored procedures?

• They must return a value

• They are only executed from SQL*Plus

• They can accept IN, OUT, IN OUT parameters

• They cannot contain exception handling

Which of the following is true about PL/SQL functions?

• They return multiple values

• They cannot use parameters

• They must return a single value

• They cannot include SQL queries

What should be ensured when performing DML operations inside overloaded procedures or functions?

• Avoid transactions

• Only SELECT statements are allowed

• Proper logic separation and use of autonomous transactions if needed

• DML is not supported in overloaded functions

What is one key feature of PL/SQL packages?

• They store binary data

• They compile on every call

• They encapsulate procedures, functions, and variables

• They cannot have global variables

What is the difference between a package specification and a body?

• The spec is not visible to users

• The body defines the implementation

• The spec includes logic

• There is no difference

What does PRAGMA AUTONOMOUS_TRANSACTION do?

• Makes transaction dependent on the caller

• Rolls back after completion

• Allows the block to commit or rollback independently

• Prevents DML operations

Which trigger type allows data validation before insert?

• AFTER INSERT

• BEFORE INSERT

• INSTEAD OF INSERT

• DDL Trigger

What is a typical use case of an INSTEAD OF trigger?

• Preventing SQL injection

• Allowing DML on views

• Logging DDL changes

• Handling compilation errors