July 5, 2012 at 9:27 am
Dan Graveen (7/5/2012)
I was wondering why the answers were checkboxes too and not just radio buttons. The answer is 10, I looked it up on msdn just to be sure. So where is 12 coming from??
Yes, I knew I would get this one wrong when I saw the answers had checkboxes.
July 5, 2012 at 9:37 am
Steve Cullen (7/5/2012)
Correct answers = 1 ???This must be one of those Monty Python type questions:
Q: What is your name?
A: Steve Cullen
Q: What is your quest?
A: I seek knowledge and wisdom about SQL Server.
Q: How many index types in SQL 2012 are there?
A: 10. No 12. AAAAAAAAAAAAAAAAAAAaaaHHHHHHHHHHHHHHHHHHHHHHHHHHH.................
+10, no +12
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 5, 2012 at 9:38 am
Correct answers:3%(7)
Incorrect answers:97%(262)
Total attempts: 269
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 5, 2012 at 9:57 am
This one was a real stinker. Seems like MSDN thinks 10 is the correct answer too!!
July 5, 2012 at 10:09 am
I think SSC should filter out these type of questions from publishing...
Regards,
Ravi.
July 5, 2012 at 10:22 am
Wow this is truly is the worst type of question. You have to answer it correct according to BOL AND read the authors mind at the same time. Then come up with the completely ridiculous notion that a count can have two answers. I appreciate the effort by the author but this is just bad. It didn't teach anything and has generated one of the lowest percentage of correct answers to date.
_______________________________________________________________
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/
July 5, 2012 at 11:53 am
Correct answers: 2% (8)
Incorrect answers: 98% (328)
Total attempts: 336
How did 8 people manage to get this one correct?
July 5, 2012 at 12:09 pm
Sean Lange (7/5/2012)
You have to answer it correct according to BOL AND read the authors mind at the same time.
It's worse than that. The author said
It can be argued that unique can go with clustered/nonclustered, as can includes, but for the sake of the question, we will go with the BOL answer.
which I interpret to mean that answer would be 8...
July 5, 2012 at 12:16 pm
Rich Weissler (7/5/2012)
Sean Lange (7/5/2012)
You have to answer it correct according to BOL AND read the authors mind at the same time.It's worse than that. The author said
It can be argued that unique can go with clustered/nonclustered, as can includes, but for the sake of the question, we will go with the BOL answer.
which I interpret to mean that answer would be 8...
ROFL now we have 2 interpretations of mind reading going on. I think the author meant that you could have unique with both clustered and non-clustered. In fact if that means that unique clustered and unique non-clustered are in fact different index types (which is really quite ludicrous) the total would be 11 and not 12 because unique would not still be considered an index on its own. So we have proven beyond a doubt that the only correct answer possible is the old stand by "It Depends". I just have no idea exactly what it depends on...:w00t:
_______________________________________________________________
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/
July 5, 2012 at 12:20 pm
Junk question.
Cheers
July 5, 2012 at 12:35 pm
twelve equals ten for large values of ten.
I like that.
July 5, 2012 at 1:29 pm
Steve Cullen (7/5/2012)
Correct answers = 1 ???This must be one of those Monty Python type questions:
Q: What is your name?
A: Steve Cullen
Q: What is your quest?
A: I seek knowledge and wisdom about SQL Server.
Q: How many index types in SQL 2012 are there?
A: 10. No 12. AAAAAAAAAAAAAAAAAAAaaaHHHHHHHHHHHHHHHHHHHHHHHHHHH.................
A terrible question that were best removed from the site and forgotten soon - if not for the above post in the discussion, which makes up for everything! 😉
Seriously. We had a similar question a few months back on the number of index types in SQL2008 or SQL2008R2. And while that one did not have two conflicting answers ticked, it did spur a lot of discussion because the whole subject is too much of a grey area.
The list given in Books Online is far too vague. Some "types" are mutually exclusive, others are not. Various combinations are possible. If "unique", "nonclustered", "with included columns", "on computed columns" and "fitered" are seperate index types, than how about a unique nonclustered filtered index on computed columns and with included columns? How about an index on a combination of computed and non computed columns? How about an index that includes computed columns?
And if minor variations on nonclustered indexes are counted as different types, then why are all types of xml indexes (primary, path seconday, value secondary, and property secondary) not counted?
If you want to test knowledge of index types, you should include a list of existing and non-existing index types and let the reader pick the "correct" ones.
(In fact, I think I am going to submit a few questions of that type right now!)
July 5, 2012 at 3:32 pm
I don't know what was the intention of this question, but it shouldn't have been included here. Having 2 possible answers where it should only have one is just pathetic.
"El" Jerry.
July 5, 2012 at 6:16 pm
I am all for multiple choice questions and do not necessarily need a hint to pick 2 or pick 3 but as someone mentioned before, a count cannot be more than one value. I thought I had an easy point today. Guess I better take up mind reading before I come back to answer more. 😀
July 5, 2012 at 8:57 pm
I was wrong.
Editor was right!
Viewing 15 posts - 31 through 45 (of 79 total)
You must be logged in to reply to this topic. Login to reply