Multiple choice

How can whole record be retrieved in PL/SQL without using any loop or cursor?

  1. Not possible

  2. Bulk collect

  3. Procedure

  4. Function

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

BULK COLLECT retrieves entire result sets into collections in a single operation, eliminating the need for explicit loops or cursor fetches. This is a performance optimization that reduces context switching between the PL/SQL and SQL engines. Procedures and functions are program units, not data retrieval mechanisms.