What is the output of the following code?DECLARE x number:= 4; BEGIN LOOP dbms ..... output.put ..... line(x); x:= x + 1; exit WHEN x > 5; END LOOP; dbms ..... output.put ..... line(x);END;

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

What is the output of the following code?DECLARE x number:= 4; BEGIN LOOP dbms ____ output.put ____ line(x); x:= x + 1; exit WHEN x > 5; END LOOP; dbms ____ output.put ____ line(x);END;

A	456
B	45
C	4
D	None of the above

Explanation:

Detailed explanation-1: -The Oracle dbms output. put line procedure allows you to write data to flat file or to direct your PL/SQL output to a screen.

Detailed explanation-2: -To increase the DBMS OUTPUT buffer size, call DBMS OUTPUT. ENABLE procedure with a larger buffer size after executing SET SERVER OUTPUT ON, for example: CALL DBMS OUTPUT. ENABLE( 50000 ); When the command SET SERVEROUTPUT OFF executes: it calls the DBMS OUTPUT.

There is 1 question to complete.

MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL