Examine the following code:
Which statement is true about the execution of the above code?
A.
It executes and displays null.
B.
It executes and the condition returns true.
C.
It executes and control goes to the else statement.
D.
It fails because no value is assigned to the v_myage variable.
C
c
C
C
“C”
(NULL < 11) is FALSE
Hi, Vitaly, Null is indetermined, so NULL < 11 is still indermined, so (NULL < 11) is still NULL
It goes directly to the Else statement, regardless if vm 11, because vm is NULL so it executes and goes straight to else statement.
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/fundamentals.htm#LNPLS251
Example 2-39 NULL Value in Equal Comparison
DECLARE
a NUMBER := NULL;
b NUMBER := NULL;
BEGIN
IF a = b THEN — yields NULL, not TRUE
DBMS_OUTPUT.PUT_LINE(‘a = b’); — not run
ELSIF a != b THEN — yields NULL, not TRUE
DBMS_OUTPUT.PUT_LINE(‘a != b’); — not run
ELSE
DBMS_OUTPUT.PUT_LINE(‘Can”t tell if two NULLs are equal’);
END IF;
END;
/
correct answer is C), go to else statement
C
the time to study or take a look at the content or web pages we’ve linked to beneath the
The information and facts mentioned inside the article are a number of the top accessible
very few internet sites that come about to be in depth beneath, from our point of view are undoubtedly effectively worth checking out
always a significant fan of linking to bloggers that I adore but really don’t get a good deal of link like from
we came across a cool internet site which you might appreciate. Take a search when you want
one of our visitors a short while ago proposed the following website
the time to study or check out the content material or websites we have linked to below the
Wonderful story, reckoned we could combine a handful of unrelated data, nevertheless seriously really worth taking a look, whoa did 1 understand about Mid East has got extra problerms also
here are some links to sites that we link to mainly because we think they may be really worth visiting
The info talked about in the post are a few of the top obtainable
please visit the internet sites we follow, like this 1, because it represents our picks in the web
Here is a great Weblog You might Obtain Fascinating that we Encourage You
check beneath, are some absolutely unrelated sites to ours, nevertheless, they are most trustworthy sources that we use
The info talked about in the write-up are some of the top accessible
below youll uncover the link to some web pages that we think you ought to visit
always a massive fan of linking to bloggers that I love but do not get a whole lot of link really like from
usually posts some pretty interesting stuff like this. If you are new to this site
please stop by the websites we stick to, such as this a single, as it represents our picks from the web