wood burning stoves 2.0
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: 32811

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 ]

http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
I agree. Here's the link: http://aspose.com/file-tools
subject: Tech Interview Questions
It's not a secret anymore!