Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Tech Interview Questions

 
Dale DeMott
Ranch Hand
Posts: 515
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34389
346
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
good != tricky

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.
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I googled 'database interview questions' and found many hits. I would focus mostly on database/sql questions and less on jdbc, but hit that too. Here is a representative link with some good questions:

http://vyaskn.tripod.com/iq.htm

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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic