Multiple choice technology platforms and products

which of the built-in performance optimization techniques used during the ETL processing

  1. PL/SQL bulk Processing

  2. Foreign key constraint manipulation

  3. Inline View technique

  4. All of the Above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

All three techniques are valid ETL performance optimization methods. PL/SQL bulk processing reduces context switching by processing data in batches rather than row-by-row. Foreign key constraint manipulation temporarily disables constraints during loading to avoid validation overhead. Inline view technique optimizes SQL queries by embedding subqueries to reduce data movement.

Keep practicing — related questions