Which statement Is true about the output of the PL/SQL block?

View the Exhibit to examine the PL/SQL code:

SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQL block?

View the Exhibit to examine the PL/SQL code:

SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQL block?

A.
The output is x = y.

B.
It produces an error.

C.
The output Is x != y.

D.
The output Is Can’t tell if x and y are equal or not.

Explanation:

Show Hint

← Previous question

Next question →

Leave a Reply 22

samkelo siyabonga ngubo

Vladimir_K

I think the following code should be here:

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;
/

Source: http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/fundamentals.htm#LNPLS002

Answer: D

PIERO

SURPRISE…………
REALLY I’D LIKE UNDERSTAND WHAT’S HAPPENING IN THE ORACLE ENGINE WHEN A SIMILAR TEST IS WORKING
I CERTAINLY KNOW THAT IN ORACLE THEORY (NOT IN IBM FOR INSTANCE) TWO IDENTICAL VARIABLES SET TO NULL ARE NOT IDENTICAL.

I’VE ACCEPTED THIS ONE THEORY,
BUT REALLY IT SEEMS STUPID DON’T ADMIT THAT TWO IDENTICAL VARIABLES, ONE WITH A VALUE AND ONE NOT, ARE NOT IDENTICAL.

PLEASE ANYONE CAN HELP TO ME TO UNDERSTAND AND ACCEPT (LEARN) THIS STUPIDITY ?

REALLY, PLEASE, HOW DOES THE ENGIN WORKS ?

SORRY FOR MY IGNORANCE, PLEASE WRITE ALSO TO MY ADDRESS ; [email protected]

THANKS A LOT

Uladzimir

oracle approach is right.
How i see it:
NULL = any value.
Any value cannot be equal any value, this why NULL != NULL

piero

Thanks a lot for the answer

please, help to me to learn what’s necessary to pass 1z0-144 exam,
really important

where can i found other terrible questions?

salvo

Anurag Saxena

roman

D
Result:
Can’t tell if two NULLs are equal

gruzker

questions are 100% valid. some answers are wrong. got 95% marks in 1z0-144 exam.thanks guys

anastasia

Hello,

Congratulations!!!!

Can you please tell me if you had questions at the exam 1zo-144 from this block or the other 2 versions of the questions found on this site??? I have see that there are 3 separate sets of questions.

gruzker

mostly questions are the same. email me [email protected] for valid dumps.