my dog learned polymorphism*
The moose likes JDBC and the fly likes Tech Interview Questions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Tech Interview Questions" Watch "Tech Interview Questions" New topic
Author

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29287
    
140

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
steve souza
Ranch Hand

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

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
 
Similar Threads
interview questions - J2EE
about face to face interview (one on one)
Interview with 3 Java Gurus Project Leaders! Help needed!
Struts interview questions
EJB interview questions ??