SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Arup Chakraborty / Included index / Latest Posts

RE: Included index

clementhuge — Mon, 01 Dec 2008 04:41:17 GMT

Answer is C. There is a bug.

RE: Included index

Tom Brown — Tue, 25 Nov 2008 03:20:09 GMT

Trick question!- how about some recognition for getting it partly right?

RE: Included index

ChrisMoix-87856 — Fri, 14 Nov 2008 11:44:28 GMT

The third choice is still a little ambiguous. From BOL:Specifies the nonkey columns to be added to the leaf level of the nonclustered index. The nonclustered index can be unique or nonunique. The third choice:non key columns included in addition to the index key columns in an index structure...makes it sound like they are included in the whole index tree, not just the leaf level.

RE: Included index

arup chakraborty — Fri, 14 Nov 2008 06:10:57 GMT

Hi All,I have seen this question created a lot of confusion. Here is a humble explanation.My question was "'What are included columns in SQL Server 2008?"There is no difference of included index in SQL Server 2005 and SQL Server 2008. Hence, the question is clear. The answer, whatever it is, applies to both SQL Server 2005 and 2008.I am not discussing the first answer. The second answer was "This is a new feature of SQL Server 2005". This statement is correct because SQL Server 2005 introduced it and SQL Server 2008 just kept the feature same.The third answer is the actual definition, hence correct.This two out of three is correct, hence the check boxes are used.I have tried to make the flat question a tricky one. I am really sorry if there is still any ambiguity.Cheers...

RE: Included index

Jack Corbett — Thu, 13 Nov 2008 14:03:12 GMT

[quote][b]Chad Crawford (11/13/2008)[/b][hr][quote]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.[/quote]I hate to spill the beans (Steve, wipe this out if you want), but if you see checkboxes on the QOD it always means there is more than one answer. When you put in a QOD, you check the answers that are correct. If you pick only one as correct, it displays radio buttons. If you pick multiple, it will use check boxes. So... if you see check boxes, always select at least two answers...:)Chad[/quote]I don't disagree Chad, but I do agree with the others who read the question and, seeing SQL 2008 in the question, ignored the SQL 2005 answer as I did as well.

RE: Included index

Chad Crawford — Thu, 13 Nov 2008 12:13:56 GMT

[quote]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.[/quote]I hate to spill the beans (Steve, wipe this out if you want), but if you see checkboxes on the QOD it always means there is more than one answer. When you put in a QOD, you check the answers that are correct. If you pick only one as correct, it displays radio buttons. If you pick multiple, it will use check boxes. So... if you see check boxes, always select at least two answers...:)Chad

RE: Included index

Lynn Pettis — Thu, 13 Nov 2008 10:35:23 GMT

[quote][b]Steve Jones - Editor (11/13/2008)[/b][hr]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.[/quote]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.

RE: Included index

Steve Jones - SSC Editor — Thu, 13 Nov 2008 08:02:56 GMT

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.

RE: Included index

mtassin — Thu, 13 Nov 2008 07:53:06 GMT

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.

RE: Included index

george sibbald — Thu, 13 Nov 2008 07:44:44 GMT

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.

RE: Included index

mtassin — Thu, 13 Nov 2008 07:38:04 GMT

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.

RE: Included index

Andy Lennon — Thu, 13 Nov 2008 07:11:31 GMT

i saw the 2008 in the question and didn't read option 2 closely enough.Dirty tricks! :P

RE: Included index

MG-148046 — Thu, 13 Nov 2008 06:27:38 GMT

Looks like someone goofed on this one ;)

RE: Included index

Vladan — Thu, 13 Nov 2008 05:37:02 GMT

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 [b]"A new feature in SQL Server 2005, non key columns included in addition to the index key columns in an index structure." [/b]as correct answer. When replying to the question, you are offered:[b]2. A new feature in SQL Server 20053. non key columns included in addition to the index key columns in an index structure[/b]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.)

RE: Included index

Mighty — Thu, 13 Nov 2008 02:31:26 GMT

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

RE: Included index

EdVassie — Thu, 13 Nov 2008 02:29:06 GMT

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.

RE: Included index

David McKinney — Thu, 13 Nov 2008 02:03:18 GMT

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

RE: Included index

jadawinwolff — Thu, 13 Nov 2008 01:30:44 GMT

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

RE: Included index

David McKinney — Thu, 13 Nov 2008 00:46:37 GMT

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!

RE: Included index

ChiragNS — Thu, 13 Nov 2008 00:25:15 GMT

i thought the third option was the right answer.

Included index

arup chakraborty — Wed, 12 Nov 2008 21:13:05 GMT

Comments posted to this topic are about the item [B]Included index[/B]