CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

SQL mock test: free online practice

15 to 30 random questions in 15 to 30 minutes, by the level you choose: joins, grouping, window functions, indexes and transactions. After you submit you get your score, your strong and weak topics, and the right answer with an explanation for every question.

Want to revise first? Read the SQL interview questions and answers.

Choose your experience

Free with a CoreHRx Jobs account: you will be asked to sign in or create one first.

What does the SQL mock test cover?

The test covers 12 topics across three levels. Each attempt picks 15 to 30 questions at random, by the level you choose, so every attempt is different.

  • Puzzles
  • Window Functions
  • Basics
  • Constraints
  • Grouping
  • Indexes
  • Joins
  • Query Tuning
  • Subqueries & CTEs
  • Transactions
  • Normalisation
  • NULL Handling

Sample SQL mock test questions

One question from each level, the way they appear in the test. A new set comes on the 1st of every month. Try it, then open the answer.

  1. FresherNormalisation

    Students can join many courses, and each course has many students. How should this be modelled?

    • One table with a column per course
    • A student_id column on courses
    • A junction table enrolments (student_id, course_id)
    • A course_ids column on students listing every course
    Show the answer

    Answer: A junction table enrolments (student_id, course_id). A many-to-many relationship needs a third table holding one row per pair, with foreign keys to both sides and a composite primary key. Lists in a column or one column per course break 1NF and do not scale.

  2. Intermediate (1-5 years)Basics

    Which MySQL 8 statement deletes the orders of inactive customers in one statement?

    • DELETE o FROM orders o JOIN customers c ON c.id = o.customer_id WHERE c.active = 0
    • DELETE FROM orders JOIN customers ON customers.id = orders.customer_id WHERE active = 0
    • DELETE orders, customers WHERE customers.active = 0
    • DELETE FROM orders o USING customers c WHERE c.active = 0
    Show the answer

    Answer: DELETE o FROM orders o JOIN customers c ON c.id = o.customer_id WHERE c.active = 0. MySQL's multi-table DELETE names the table to delete from before FROM, then joins. PostgreSQL uses DELETE FROM orders o USING customers c WHERE c.id = o.customer_id AND ..., which needs the join condition in WHERE.

  3. Experienced (5+ years)Transactions

    GST rules require invoice numbers without gaps. Why is an AUTO_INCREMENT or sequence id unsuitable, and what works?

    • Ids can repeat after a server restart; use a UUID for each invoice
    • Rolled-back inserts burn ids; use a counter row locked FOR UPDATE
    • Ids are not unique across tables; use MAX(id) + 1 instead
    • Ids are too short; use a BIGINT AUTO_INCREMENT instead
    Show the answer

    Answer: Rolled-back inserts burn ids; use a counter row locked FOR UPDATE. Sequences hand out values outside the transaction, so a rollback or failed insert leaves a gap forever. A per-series counter row incremented under a row lock inside the invoice transaction gives gapless numbers, at the cost of serialising invoice creation.

Take the full SQL mock test: 15 to 30 questions and 15 to 30 minutes, by level.

How is the SQL mock test scored?

A question counts as right only when you pick exactly the right option, or all the right options where it says so; a question left blank counts as wrong. Your score is the share of the test's questions you got right (15 to 30, by level). The result also scores every topic, so you know what to revise before the interview.

  • 75% or more in a topica strength
  • 50% to 74%worth a revision
  • Under 50%a topic to work on

SQL mock test: questions people ask

Is the SQL mock test free?

Yes. The SQL mock test is free. You need a free CoreHRx Jobs account to start it, so your score and the topics to work on are saved.

How many questions are in the SQL mock test?

It depends on the level: Fresher has 15 questions in 15 minutes, Intermediate has 20 questions in 20 minutes, Experienced has 30 questions in 30 minutes. They are multiple-choice questions picked at random from a larger bank of SQL questions at your level, so every attempt is different.

Which SQL topics does the test cover?

The questions cover Puzzles, Window Functions, Basics, Constraints, Grouping, Indexes, Joins, Query Tuning, Subqueries & CTEs, Transactions, Normalisation, NULL Handling. Your result shows how you did in each topic.

Which level should I choose?

Fresher if you are a student or have less than a year of experience, Intermediate for 1 to 5 years at work, and Experienced for 5 years or more.

Can employers see my SQL score?

Only your best SQL score, and only when it is 60% or more. It shows on the job applications you send on CoreHRx. Lower scores stay private.

Can I take the SQL mock test again?

Yes, up to 10 tests a day. Each attempt picks questions you have not seen recently first.

All mock tests