codebyo (11/9/2011)
Wow, very elaborated question.It made my brain hurt for a second.
I've got 3/4 options right.
I only missed one which should have been basic knowledge to me:
"The amount of space used DOES depend on the fragmentation of the index that supports the PRIMARY KEY constraint."
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?" :w00t:
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn