BEGIN a := 100; IF( a < 20 ) THEN dbms_output.put_line('a – McqOptions

MCQOPTIONS

1.	BEGIN a := 100; IF( a < 20 ) THEN dbms_output.put_line('a is less than 20 ' ); ELSE dbms_output.put_line('a is not less than 20 ' ); END IF; END; 4.Which of the following is true?
A.	It's ELSIF, not ELSEIF.
B.	An IF-THEN statement can have zero or one ELSE's and it must come after any ELSIF's.
C.	Once an ELSIF succeeds, none of the remaining ELSIF's or ELSE's will be tested.
D.	All of the above
Answer» E.

Discussion

No Comment Found

Related MCQs

The searchedCASEstatement has no selector and theWHENclauses of the statement contain search conditions that give Boolean values.
In which Oracle does the PL/SQL Continue Statement is supported?
What are the selectors in case of CASE statement?
DECLARE grade char(1) := 'A'; BEGIN CASE grade when 'A' then dbms_output.put_line('Excellent'); when 'B' then dbms_output.put_line('Very good'); when 'C' then dbms_output.put_line('Well done'); when 'D' then dbms_output.put_line('You passed'); when 'F' then dbms_output.put_line('Better try again'); else dbms_output.put_line('No such grade'); END CASE; END; 7.CASE statement uses which keyword to work like IF statement?
The CASE statement selects one sequence of statements to execute.
BEGIN a := 100; IF( a < 20 ) THEN dbms_output.put_line('a is less than 20 ' ); ELSE dbms_output.put_line('a is not less than 20 ' ); END IF; END; 4.Which of the following is true?
BEGIN a:= 10; IF( a < 20 ) THEN dbms_output.put_line('a is less than 20 ' ); END IF; dbms_output.put_line('value of a is : ' || a); END;3.What is output for the following code?
What is output for the following code?
The __________ associates a condition with a sequence of statements enclosed by the keywords THEN and END IF.