exampilot.ai

Programming · free timed test

SQL and Databases

For freshers and early-career developers, testers and data analysts facing technical screens. Covers SELECT and filtering, joins, aggregation with GROUP BY and HAVING, keys and constraints, normalisation, transactions and ACID, indexes, and DDL versus DML in standard SQL. A pass means you can write and reason about everyday queries correctly.

20 minutes 25 questions Pass mark 60%

What it covers

25 multiple-choice questions, four options each, drawn from these topics. The result page scores every topic separately so you can see where the marks went.

  • SELECT and Filtering
  • Joins
  • Aggregation and GROUP BY
  • Keys and Constraints
  • Normalisation
  • Transactions and ACID
  • Indexes
  • DDL and DML

Good forCampus placementsData analystBackendTechnical round

How the test runs

  • The timer runs on the server

    It starts when you press Start and keeps running if you reload, switch tabs or lose connection. Under a minute left, the clock turns red.

  • Answers save as you go

    Every change is saved within seconds and again every ten seconds. Leave and come back while time remains and the test resumes where you were.

  • Auto-submit at zero

    When the clock hits zero, whatever you have answered is submitted and scored. Unanswered questions count as wrong; there is no negative marking.

  • One attempt in progress

    You can have one attempt of this test running at a time. Submit it (or let it expire) to start a fresh one with a new timer.

  • Keyboard friendly

    Keys 1 to 4 choose an option, the left and right arrows move between questions, and the palette jumps anywhere. Flag a question to come back to it.

After the test

The score tells you where you stand; these are where the preparation happens.

More tests in programming

Free test

20 min · 25 questions