>I vote for A & C. I can't see any way that D & E could affect anything. B could if there were no indexes on the table and the table scan was being blocked by lock held by another connection.
>
>-Mike

Thanks Mike,

I'll find out today when I take the exam, I actually got the question off of mcsebraindum.com or something like that (unfortunately there was no answer), I haven't taken the exam yet, so I've not violated any of the NDA as I haven't agreed to it yet, but I'll keep that in mind for future use !

bob