O
Oracle Database 11g: Program with PL/SQL
106 Questions
Question No. 1
View the Exhibit to examine the PL/SQL code:
DECLARE
x NUMBER := 5;
y NUMBER := NULL;
BEGIN
IF x != y THEN — yields NULL, not TRUE
DBMS_OUTPUT.PUT_LINE(‘x != y’); — not run
ELSIF x = y THEN — also yields NULL
DBMS_OUTPUT.PUT_LINE(‘x = y’);
ELSE
DBMS_OUTPUT.PUT_LINE
(‘Can’t tell if x and y are equal or not.’);
END IF;
END;
/
SERVEROUTPUT is on for the session. Which statement is true about the output of the PL/SQL block?
Choose the correct option from the given list.
01 / 106