Jitbit Blog - please Subscribe if you like this post

Jitbit's SQL interview questions

May 27 2013

Since we're selling help desk ticketing system (both on-premise and saas versions) we have lots of IT people among our customers - programmers, IT-support agents, system administrators, database engineers... In other words - there must be a lot of engineers reading this blog. So we decided to share our SQL interview questions we give our candidates, you people might find it useful.

Even though most of our work is based around Microsoft SQL Server and the test machine we provide is connected to an MS SQL database, the test would fit any database engine - Oracle, PostgreSQL, MySQL - anything, since it's very basic.

Some people might say it is too basic, but that's not the point. The test's job is not to tell genius and rockstars from "normal" devs. The purpose is to save you time and quickly filter out DB-experienced guys from the ones that just claim to be.

The test

We prepared a simple database scheme and ask the following questions

Feel free to use it. Like I said, it's very basic. And there's more than one correct solution for each of these questions.

Back to the blog or Subscribe if you liked the article

comments powered by Disqus