File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Tech Interview Questions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Tech Interview Questions" Watch "Tech Interview Questions" New topic

Tech Interview Questions

Dale DeMott
Ranch Hand

Joined: Nov 02, 2000
Posts: 515
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)
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33113

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 862
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:

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 ] - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
I agree. Here's the link:
subject: Tech Interview Questions
It's not a secret anymore!