Multiple choice technology databases

Limitation for level of Subquery Nesting in a PL/SQL program

  1. No limitations

  2. 542

  3. 254

  4. 245

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

PL/SQL subqueries can be nested up to 254 levels deep. This limitation prevents excessive nesting that could impact performance and code maintainability.