SET option hierarchy

  • Good information.

  • Confusing question because of #4, but considering all others are correct, #5 would've been the right answer.

    Cheers,

    GG.

    πŸ˜€

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • I would have chosen "All of the above" if it wasn't for two contradictory options. πŸ™‚

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • I too was in a quandry trying to resolve the conflict of the last part of option 4. After losing a few hairs I choose poorly. I did however learn/was reminded of something so that is worth a point. Keep up the questions.

    Al Kessler
    It's too bad that
    Common Sense Isn't

  • Interesting question -- thanks!

  • Good question and certainly a learning point for many people. For this reason alone the question was a good one.

    It is unfortunate about the answers. I too was not sure which incorrect answer was the correct one. I chose the incorrect incorrect answer.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • SQLRNNR (2/1/2012)


    Maybe somebody will be along later to correct the answer???

    Let's hope so.

    Tom

  • honza.mf (2/1/2012)


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

    +1

    Forum disucussion for the win again today

  • I don't understand how it can be 'all of the above' when answers 3 and 4 are in direct opposition.

  • According to this reference http://msdn.microsoft.com/en-us/library/ms191203.aspx, there are only 3 rules in hierarchy of options. I would like to know from where comes option no. 4?

    Option no. 5 should have to be "Almost all of the above" 😎

  • Narud (2/1/2012)


    According to this reference http://msdn.microsoft.com/en-us/library/ms191203.aspx, there are only 3 rules in hierarchy of options. I would like to know from where comes option no. 4?

    Option no. 5 should have to be "Almost all of the above" 😎

    That reference lists four levels: instance, database, batch, statement.

    I like "Almost all of the above".

    Tom

  • L' Eomot InversΓ© (2/1/2012)


    Narud (2/1/2012)


    According to this reference http://msdn.microsoft.com/en-us/library/ms191203.aspx, there are only 3 rules in hierarchy of options. I would like to know from where comes option no. 4?

    Option no. 5 should have to be "Almost all of the above" 😎

    That reference lists four levels: instance, database, batch, statement.

    I like "Almost all of the above".

    So do I.

    I think that one should not assume that authors of QotDs will get everything definitely and absolutely right. They are humans, so there will be an occassional slip.

    As I read it, "All of the above" was the most correct of the offered options, one good enough for a rainy Wednesday.

  • Another poorly worded question and answer set.

  • I was going to choose All of the Above but then re-read the answers and thought that "All" could not be right since there were 2 answers that were mutually exclusive. It is still a good question, although the point has been mostly lost due to poor answer choices.

  • KWymore (2/1/2012)


    I was going to choose All of the Above but then re-read the answers and thought that "All" could not be right since there were 2 answers that were mutually exclusive. It is still a good question, although the point has been mostly lost due to poor answer choices.

    The point is only lost if you focus more on the added answer than what the question was trying to get at. I got it wrong because I assumed at "all of the above" was a last minute add to get another option because it was impossible for all the other answers to be correct. However, my reasoning that the first three options were all right based on what I knew about the topic was right so I still got the point of the question.

    I understand that the problematic option isn't one that the author initially put in but I'm wondering if this would have been better formatted as a multiple choice question. Check any of the answers that apply, leave out the last two options, and add a couple others so not all were selected (or not, nothing wrong with all being right).

Viewing 15 posts - 31 through 45 (of 61 total)

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