Multiple choice technology databases

select level from dual connect by level between 3 and 50; o/p:

  1. NULL

  2. Values 3 to 50

  3. 1

  4. 0

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

CONNECT BY generates rows starting at LEVEL=1. The filtering condition LEVEL BETWEEN 3 AND 50 is applied AFTER row generation. But the condition fails for LEVEL=1 and LEVEL=2, stopping generation. Only LEVEL=1 satisfies 1 BETWEEN 3 AND 50 = FALSE, so no rows generated beyond first. Oracle returns just the initial row with LEVEL=1.