When I’m interviewing, I ask questions on any or all of the below topics, depending what position I’m interviewing for.
Indexes – types, differences.
Statistics – what, why
Database corruption – how to find, how to fix
Backups – types
Recovery modes – impact on recovery, backups
Restores – How, what order, common errors
Deadlock – causes, solutions (no, isoaltion levels aren’t a cause or a solution)
Optimisation – how, methods
Performance monitoring – what do you look for.
Database theory – assorted questions
T-SQL – assorted (though I leave most of that to the technical test)
Like Grant, I’m not hiring entry level. I’m currently looking for someone to assis me with optimisation and complex problems. When I do interview entry levels, I’m much, much more lenient.
That said, if you say you’re an expert on SQL, expect me to ask expert level questions. If you say you’re average, I’ll be asking average level questions.
As for your initial question, I’d guess he was looking for Select – nonclustered and insert – clustered. It’s a massive simplification, but….
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