Multiple choice technology databases

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

  1. 1

  2. Values 1 to 50

  3. Values 0 to 50

  4. 0

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

CONNECT BY with LEVEL generates hierarchical rows. LEVEL starts at 1, increments by 1. The condition LEVEL BETWEEN 0 AND 50 is true for LEVEL=1 through 50. Output is values 1 through 50.