Was wondering if any of you had some good SQL / Database tech interview questions. I'd love to hear them and the solutions. This would help me catch those tricky questions that seem to be thrown at me during a tricky tech.
By failing to prepare, you are preparing to fail.<br />Benjamin Franklin (1706 - 1790)
A lot of questions I consider good aren't trick questions, but I digress. I think good basic questions would have to do with how to actually use JDBC. More advanced questions would deal with driver types, transactions and advanced SQL.
I like to ask pretty basic questions. What I have found is people that really know their stuff answer the question deeply and ones that don't know it ask for clarification on what is really a basic question. By basic questions I mean ones that deal with concepts that all should know: views, triggers, roles, logins, cursors, joins, normalization, referential integrity, jdbc and the like.
I am often surprised when I ask a question like: "Describe what a view is", how many times people ask for clarification on the question or think that it is a copy of the data. [ August 28, 2006: Message edited by: steve souza ]