November 12, 2008 at 9:13 pm
Comments posted to this topic are about the item Included index
November 13, 2008 at 12:25 am
i thought the third option was the right answer.
"Keep Trying"
November 13, 2008 at 12:46 am
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!
November 13, 2008 at 1:30 am
i fell for it also. it's multiple choice and the question itself doesnt indicate this (answers 2 AND 3 are correct).
November 13, 2008 at 2:03 am
ok...fair enough. A bit of dumb on both sides!
November 13, 2008 at 2:29 am
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
November 13, 2008 at 2:31 am
Answer should be C.
Even though it is not a new feature in 2008, it still is what it is (non key columns included...).
November 13, 2008 at 5:37 am
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.)
November 13, 2008 at 6:27 am
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.
November 13, 2008 at 7:11 am
i saw the 2008 in the question and didn't read option 2 closely enough.
Dirty tricks! 😛
November 13, 2008 at 7:38 am
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.
November 13, 2008 at 7:44 am
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.
---------------------------------------------------------------------
November 13, 2008 at 7:53 am
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.
November 13, 2008 at 8:02 am
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.
November 13, 2008 at 10:35 am
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 20 total)
You must be logged in to reply to this topic. Login to reply