O

Oracle Database 11g: Program with PL/SQL

106 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

View the Exhibit to examine the PL/SQL code:

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

0 Discussions

Trending Exams