Practice Questions

Which PL/SQL construct is used to handle runtime errors?

A. LOOP B. EXCEPTION C. TRIGGER D. FUNCTION

Which cursor attribute returns TRUE if a row was fetched successfully?

A. %ROWCOUNT B. %FOUND C. %ISOPEN D. %NOTFOUND

Which keyword is used to execute dynamic SQL in PL/SQL?

A. RUN B. EXECUTE C. EXECUTE IMMEDIATE D. DYNAMIC SQL

What is the default parameter mode in PL/SQL procedures?

A. OUT B. IN OUT C. IN D. RETURN

Which collection type has a fixed maximum size?

A. Nested Table B. Associative Array C. VARRAY D. Cursor

Which trigger fires once for each row affected by a DML statement?

A. Statement Trigger B. Row-Level Trigger C. System Trigger D. Schema Trigger