select level from dual connect by level between 3 and 50; o/p:
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.