Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»»

Table space usage 1 Expand / Collapse
Author
Message
Posted Wednesday, November 9, 2011 6:38 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, August 22, 2014 12:43 PM
Points: 581, Visits: 732
Great question. I got it wrong, because my reading comprehension needs to improve. I saw the foreign keys, the question asked about an index that supports those foreign keys, and I incorrectly made an surmised that the question was assuming the indexes were present, even though they are not implicitly created by the statement. The mistake is mine. You are one of the few question providers whose questions I can take a face value, and I needed to do that here.

Thanks again, and I look forward to your next question.

Matt
Post #1202805
Posted Wednesday, November 9, 2011 6:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 9:04 AM
Points: 1,623, Visits: 357
As noted in a previous discussion, I (almost) always look up the subject of the QOTD, due to the interesting little tidbits that I gain on the side. I did so again today, but happily my initial answers were correct (which is not always the case). Looking back, I don't think this was too difficult a question, but I am one of those whose initial reaction to a multiple-answer multiple choice question can't be repeated here. But I will admit that one generally has to understand a multiple-answer multiple choice question in order to be correct rather than simply deducing the correct choice as is often possible with single-answer multiple choice questions. Good question!

Post #1202807
Posted Wednesday, November 9, 2011 6:43 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, August 18, 2014 7:25 AM
Points: 989, Visits: 1,823
Yeah, in my case I am so used to the indexes being created as a part of making the foreign key that I failed to notice that they weren't part of creating the table here. So that was what caused me to miss this one.
Post #1202810
Posted Wednesday, November 9, 2011 6:53 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:59 AM
Points: 897, Visits: 1,488
Thomas Abraham (11/9/2011)
Same here, including the part wrong. Forgot that primary key generates an index implicitly. Doh. Partial credit?

Reminds me of my college days, when students would beg for "partial credit". One prof in the dept. would rant loudly, "Partial Credit! Partial Credit! Would you go to a doctor that always got partial credit?"


Hahahaha, priceless! That's a smart teacher.

I really enjoyed the question as it was not too hard as it seemed at first look but we needed to pay attention to detail and lots of text.

Best regards,


Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2
Post #1202819
Posted Wednesday, November 9, 2011 7:04 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:03 AM
Points: 3,928, Visits: 5,116
Thanks for the question, Hugo
Looking forward to the next ones in the series...


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1202835
Posted Wednesday, November 9, 2011 8:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, June 26, 2014 7:28 AM
Points: 257, Visits: 902
Hugo Kornelis (11/9/2011)

I must say that the low rate of correct answers surprises me. I intended this question to be a relatively easy first question in a series (hence the "1" in the title). I have already submitted the second one, and I won't change that - but I'll have to rethink the difficulty level of the remaining planned questions (that I did not submit yet).


The number of ways of answering correctly: 1
The number of ways of answering incorrectly: many

The is no "partially correct" option. I might have complained about mixing 4 different ideas (and their negation) into the multiple-choice answer, but I thought "Grow up, these are professionals we're talking about" :) So I'm sharing this thought to possibly explain why results are skewed to 9% correct.

I think there's also a psychological impact of 8 checkboxes - the answer seems simple enough, but then there's the second-guessing. After that first moment of hesitation, we're much less likely to check all (and only) the right boxes.

Anyway, I admit I was guessing at the answers - but I think this is a great example of an edge case of SQL ServerCentral Question of the Day. Maybe if more questions were written this way we'd be more accustomed to it?
Post #1202912
Posted Wednesday, November 9, 2011 8:27 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:10 AM
Points: 3,307, Visits: 1,980
Nice question Hugo. I got 3 out of 4 right and learned something so I'm happy with that.
Post #1202951
Posted Wednesday, November 9, 2011 8:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:24 AM
Points: 5,977, Visits: 8,239
Mike Dougherty-384281 (11/9/2011)
The number of ways of answering correctly: 1
The number of ways of answering incorrectly: many

The is no "partially correct" option. I might have complained about mixing 4 different ideas (and their negation) into the multiple-choice answer, but I thought "Grow up, these are professionals we're talking about" :) So I'm sharing this thought to possibly explain why results are skewed to 9% correct.

I think there's also a psychological impact of 8 checkboxes - the answer seems simple enough, but then there's the second-guessing. After that first moment of hesitation, we're much less likely to check all (and only) the right boxes.

Anyway, I admit I was guessing at the answers - but I think this is a great example of an edge case of SQL ServerCentral Question of the Day. Maybe if more questions were written this way we'd be more accustomed to it?

I know multiple-answers questions are not the most popular, but in this case there are four obviously mutually exclusive answer pairs, so you are basically facing four yes/no questions combined into one question. I thought that would not be overly hard. Apparently, I was wrong. (It's also intrigueing that for none of the yes/no pairs, the answers given add up to 100% - obviously, there are people who overlook both the "choose 4" in the question and the fact that the options are mutually exclusive so that there have to be four correct answers.

FWIW, the second question in this series will be a single-answer one (albeit with no less than seven options to choose from), and I just submitted the third question as a simple Yes/No question. I'll keep the rest on hold until I know how the second one is received, so that I can adjust the difficulty as needed.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1202972
Posted Wednesday, November 9, 2011 8:47 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:20 AM
Points: 1,740, Visits: 6,366
Hugo Kornelis (11/9/2011)
So it is not only, as you say, reasonable to assume that the question is about space for the table being discussed - it is explicitly stated!


That still didn't stop me make the assumption that it was referring to the other table...
Post #1202983
Posted Wednesday, November 9, 2011 8:55 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:06 AM
Points: 2,055, Visits: 2,046
Hugo Kornelis (11/9/2011)
... Advance warning as a special service for those who take the time to read the discussion - the next question in this series (scheduled to go live in about a week) will involve some heavy arithmetic!

Oh great, just when we start getting the question authors trained to not turn us into human SQL parsers. Now we have to train them not to turn us into human calculators!!!

Just kidding.

Keep the great questions coming Hugo!
Post #1202991
« Prev Topic | Next Topic »

Add to briefcase «««12345»»»

Permissions Expand / Collapse