Post reply

SET option hierarchy

  • January 31, 2012 at 9:16 pm

    #263583

    Comments posted to this topic are about the item SET option hierarchy

  • January 31, 2012 at 9:38 pm

    #1441032

    Good one, Thanks.

    M&M

  • January 31, 2012 at 10:33 pm

    #1441036

    I disagree with the answers (2nd time in the same week). Here's why:

    3. A hint overrides a SET option

    4. A database option overrides an instance option and a SET option overrides a database option, but a hint does not override a SET option

    Those are 2 contradicting statements. The correct answer therefore cannot be:

    5. All of the above

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • January 31, 2012 at 10:43 pm

    #1441039

    Nakul Vachhrajani (1/31/2012)

    I disagree with the answers (2nd time in the same week). Here's why:

    3. A hint overrides a SET option

    4. A database option overrides an instance option and a SET option overrides a database option, but a hint does not override a SET option

    Those are 2 contradicting statements. The correct answer therefore cannot be:

    5. All of the above

    Good catch, the author might have missed it due to oversight 🙂

    M&M

  • January 31, 2012 at 11:11 pm

    #1441043

    A confused question with no right answer. All of the above indeed :rolleyes:

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • January 31, 2012 at 11:19 pm

    #1441044

    As pointed out above, the 3rd and 4th answer are mutually exclusive.

    So "all of the above" is pretty impossible.

    But I like the question in itself.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 1, 2012 at 12:00 am

    #1441053

    The correct answer can be : option 4

  • February 1, 2012 at 12:49 am

    #1441056

    naresh.cherukumalli 33439 (2/1/2012)

    The correct answer can be : option 4

    A hint overrides a SET option.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 1, 2012 at 1:08 am

    #1441065

    Nakul Vachhrajani (1/31/2012)

    I disagree with the answers (2nd time in the same week). Here's why:

    3. A hint overrides a SET option

    4. A database option overrides an instance option and a SET option overrides a database option, but a hint does not override a SET option

    Those are 2 contradicting statements. The correct answer therefore cannot be:

    5. All of the above

    Exactly what i was going to say! Cant be correct.

  • February 1, 2012 at 1:09 am

    #1441066

    I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.


    See, understand, learn, try, use efficient
    © Dr.Plch

  • February 1, 2012 at 1:14 am

    #1441070

    honza.mf (2/1/2012)

    I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.

    :laugh: I like it!

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • February 1, 2012 at 1:25 am

    #1441074

    SQL Kiwi (2/1/2012)

    honza.mf (2/1/2012)

    I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.

    :laugh: I like it!

    I like it too! 🙂

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • February 1, 2012 at 1:32 am

    #1441075

    honza.mf (2/1/2012)

    I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.

    😎 Got the same idea while choosing answer.

  • February 1, 2012 at 1:34 am

    #1441077

    Nakul Vachhrajani (2/1/2012)

    SQL Kiwi (2/1/2012)

    honza.mf (2/1/2012)

    I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.

    :laugh: I like it!

    I like it too! 🙂

    I vote for that too :). In present form, there is no right answer. This happens time to time on QotD, no big deal really thanks to the following discussions, which usually clear things out and adds learning value :).

    Cheers

    Istvan

  • February 1, 2012 at 1:50 am

    #1441079

    Once upon a time I had a dream to write a QotD with a correct answer "It depends". I succeeded.

    Now I'm going to imagine one with two answers "All of above" and "All of beneath" :w00t:


    See, understand, learn, try, use efficient
    © Dr.Plch

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

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