NULL Tests

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720887

    Comments posted to this topic are about the item NULL Tests

  • frederico_fonseca

    SSChampion

    Points: 14743

    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

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71907

    frederico_fonseca - Sunday, July 29, 2018 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

    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”

  • RKaram

    SSCommitted

    Points: 1518

    πŸ˜€ Nice One πŸ˜€

    rkaram

  • RoNoS

    SSC Eights!

    Points: 956

    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)

  • octav 25679

    Valued Member

    Points: 55

    frederico_fonseca - Sunday, July 29, 2018 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

    the same here πŸ™‚

  • PaulyDee

    SSC Veteran

    Points: 225

    frederico_fonseca - Sunday, July 29, 2018 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

    Yep, same here!

  • morlindk

    SSCrazy

    Points: 2294

    Ah, well - Errare humanum est.

  • Shayn Thomas

    SSCertifiable

    Points: 5637

    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

  • amd.repetto

    Ten Centuries

    Points: 1027

    frederico_fonseca - Sunday, July 29, 2018 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

    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

  • Mighty

    SSCrazy Eights

    Points: 8842

    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.

  • gvoshol 73146

    Hall of Fame

    Points: 3191

    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.

  • PurpleLady

    SSCertifiable

    Points: 7647

    frederico_fonseca - Sunday, July 29, 2018 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

    Add another to the peanut gallery... I was tempted to select B since A and B are the same but...

  • sestell1

    SSChampion

    Points: 10230

    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:

  • Arno.Hubert.Janssen

    SSCrazy

    Points: 2368

    Picked the 2nd option and got it right...

Viewing 15 posts - 1 through 15 (of 26 total)

You must be logged in to reply to this topic. Login to reply