L' Eomot Inversé (9/18/2013)
That's a nice example of utterly pointless knowledge that, if one needed it, could easily be looked up; and certanly isn't going to be needed often enough to be worth learning to avoid the necessesity of that look up. In other words, something which is absolutely suitable for a "brain dump" and also absolutely useless as a test of how competent someone will be.
So it's a perfect exampleof how utterly meaningless certifications at that level are.
That type of question is unfortunately common in the sample tests, from MS and others, never seen anything like that in the actual exams, SQL 2000 or anything later. Sample exams!=real exams. They should be, but they're not. I've looked at practice exams from MS after having written the real exams they're supposed to help prepare one for, and they're often worse than useless with too many memorisation questions, which don't appear in the real exams.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass