Included index

  • arup chakraborty

    Hall of Fame

    Points: 3640

    Comments posted to this topic are about the item Included index

  • ChiragNS

    One Orange Chip

    Points: 26137

    i thought the third option was the right answer.

    "Keep Trying"

  • David McKinney

    SSChampion

    Points: 10449

    yeah, me too. I don't get it!

    Plus the question is wierd, as they're a 2005 feature. And answer 2 makes no sense, given the question.

    But it is early....so maybe I've missed something dumb!

  • jadawinwolff

    SSC Rookie

    Points: 41

    i fell for it also. it's multiple choice and the question itself doesnt indicate this (answers 2 AND 3 are correct).

  • David McKinney

    SSChampion

    Points: 10449

    ok...fair enough. A bit of dumb on both sides!

  • EdVassie

    SSC Guru

    Points: 60274

    The question was 'What are included columns in SQL Server 2008'. I don't see that the status of included columns in SQL Server 2005 is relevant to the question.

    If the question just said 'What are included columns in SQL Server' then options 2 and 3 are correct, but IMHO only 3 is right for the question as asked.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • Mighty

    SSCrazy Eights

    Points: 8814

    Answer should be C.

    Even though it is not a new feature in 2008, it still is what it is (non key columns included...).

  • Vladan

    SSC-Insane

    Points: 22072

    IMHO the problem is not whether it 2 or 3 is correct, but what is the answer 3?

    If you read the "Sorry you were wrong" message, you!ll see that it gives

    "A new feature in SQL Server 2005, non key columns included in addition to the index key columns in an index structure."

    as correct answer.

    When replying to the question, you are offered:

    2. A new feature in SQL Server 2005

    3. non key columns included in addition to the index key columns in an index structure

    That means, answer 2 was incorrectly entered by the author - part of it is offered as answer 2 and part as answer 3 - while answer 3 was not entered at all and no one knows what it was. (BTW, If you look at the answer 3, you might notice that it starts with a small letter, not capital.)

  • MG-148046

    SSCrazy Eights

    Points: 9945

    Looks like someone goofed on this one 😉

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • Andy Lennon

    SSCrazy

    Points: 2354

    i saw the 2008 in the question and didn't read option 2 closely enough.

    Dirty tricks! 😛

  • mtassin

    SSC-Insane

    Points: 23099

    Both 2 and 3 are correct.

    These days it's very important to know when features were introduced. Include wasn't an option pre-2005. What it does is part 3.

    Check boxes mean that there are possibly more than 1 correct answer and you need to select all of them. It's no better or worse than Microsoft certifications with multiple choice questions where multiple answers may be correct.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • george sibbald

    SSC Guru

    Points: 104200

    If the question is 'what are included columns in 2008', I don't see how 'a new feature introduced in 2005' can be part of the answer. It might be a correct statement but its not an answer to the question as asked.

    ---------------------------------------------------------------------

  • mtassin

    SSC-Insane

    Points: 23099

    And that's where I would disagree. Included columns in 2008 are a feature that was introduced in 2005. They're nothing new to it.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720436

    I can see where the question is a little ambiguously worded. I shall add a "select all" and award back points to people for this one.

  • Lynn Pettis

    SSC Guru

    Points: 442342

    Steve Jones - Editor (11/13/2008)


    I can see where the question is a little ambiguously worded. I shall add a "select all" and award back points to people for this one.

    Slightly off-topic, but on the Member scores and standings page, my points don't match between Question of the Day and Question of the Day Breakdown. My points in the Breakdown section is higher the Question of the Day section.

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

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