What Will Be The Output Of The Following Plsql Codep Pre #637

What will be the output of the following PL/SQL code?</p> <pre><code class="language-sql">DECLARE a number(2) := 100; BEGIN IF (a < 50) THEN dbms_output.put_line('Value of a is less than 50' ); ELSEIF (a < 75) THEN dbms_output.put_line('Value of a is less than 75' ); ELSE dbms_output.put_line('Value of a is greater than 75'); END IF; dbms_output.put_line('Value of a is: '|| a ); END;</code></pre>

This multiple choice question (MCQ) is related to the book/course gs gs115 Structured Query Language. It can also be found in gs gs115 PL/SQL Data Types and DBMS Output - PL/SQL DBMS Output - Quiz No.1.

DECLARE a number(2) := 100; BEGIN IF (a < 50) THEN dbms_output.put_line('Value of a is less than 50' ); ELSEIF (a < 75) THEN dbms_output.put_line('Value of a is less than 75' ); ELSE dbms_output.put_line('Value of a is  greater than 75'); END IF; dbms_output.put_line('Value of a is: '|| a ); END;

Value of a is less than 50 Value of a is 100

Value of a is less than 75 Value of a is 100

Value of a is greater than 75 Value of a is 100