I'd say most of those questions are less about thinking logically and more about stress response.

During an interview with a Sprint VP I was asked the "where do you see...

I'm part of a project developing an application for states to use when managing various programs. As such, we have to provide a data dictionary as part of the...

This is the way I've done the PK determination:

Join in sysobjects:

FROM sys.columns AS c

INNER JOIN sysobjects so

ON c.object_id = so.id

Then use this...