July 28, 2018 at 1:59 pm
Comments posted to this topic are about the item NULL Tests
July 29, 2018 at 1:21 am
small error on it as first 2 options are the same - did pick up one of the 2 set nulls off and got the wrong one
July 29, 2018 at 10:55 pm
frederico_fonseca - Sunday, July 29, 2018 1:21 AMsmall error on it as first 2 options are the same - did pick up one of the 2 set nulls off and got the wrong one
concur.
fortunately selected the right one.
i recon this conversation could get messy....
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
July 30, 2018 at 12:07 am
😀 Nice One 😀
rkaram
July 30, 2018 at 1:22 am
The answers:
A: SET ANSI_NULLS OFF
B: SET ANSI_NULLS OFF
C: SET ANSI_NULL_DFLT_OFF ON
D: SET ANSI_NULL_DFLT_ON ON
A: Same as B
B: Same as A
C: This is already the case (I have the default settings for a US English installation already. These are: ANSI_NULL_DFLT_OFF - ON)
July 30, 2018 at 1:31 am
frederico_fonseca - Sunday, July 29, 2018 1:21 AMsmall error on it as first 2 options are the same - did pick up one of the 2 set nulls off and got the wrong one
the same here 🙂
July 30, 2018 at 2:21 am
frederico_fonseca - Sunday, July 29, 2018 1:21 AMsmall error on it as first 2 options are the same - did pick up one of the 2 set nulls off and got the wrong one
Yep, same here!
July 30, 2018 at 2:32 am
Ah, well - Errare humanum est.
July 30, 2018 at 3:30 am
Guessed which of the correct answers was the correct answer and got it correct 🙂
Thanks
---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know
July 30, 2018 at 3:30 am
frederico_fonseca - Sunday, July 29, 2018 1:21 AMsmall error on it as first 2 options are the same - did pick up one of the 2 set nulls off and got the wrong one
The same happened to me, I picked the fiesta one (as both were the same) and I got a wrong answer
A. Mauricio Repetto
ML Engineer
July 30, 2018 at 4:27 am
Same for me for selection the "wrong" right option.
But probably none of the answers is right, or it should have been a combination of options. The thing is that one thing not mentioned, but that is very important here, is the value for the database option ANSI_NULL_DEFAULT. If this is OFF, then the insert query would not even have worked, since the columns would have been created with NOT NULL, because of the default settings as specified of ANSI_NULL_DEFAULT_OFF and ANSI_NULL_DEFAULT_ON.
In SSMS you might not notice this, because of the fact that the query options by default set ANSI_NULL_DEFAULT_ON to ON.
July 30, 2018 at 5:12 am
Why don't we just do it the correct way for handling nulls:
WHERE nt.myvalue IS NULL
Since the first two choices were the same, I thought neither one of them could be correct. So I picked between the other two.
July 30, 2018 at 6:00 am
frederico_fonseca - Sunday, July 29, 2018 1:21 AMsmall error on it as first 2 options are the same - did pick up one of the 2 set nulls off and got the wrong one
Add another to the peanut gallery... I was tempted to select B since A and B are the same but...
July 30, 2018 at 6:29 am
I went with the first, thinking there was a pattern to what the answers were meant to be.
Looks like that wasn't the case. :crazy::hehe:
July 30, 2018 at 6:37 am
Picked the 2nd option and got it right...
Viewing 15 posts - 1 through 15 (of 25 total)
You must be logged in to reply to this topic. Login to reply