Free SQL MCQ Test — Online MySQL Quiz with Instant Score

Topic-wise SQL multiple-choice questions at real fresher-interview level — queries, joins, keys and functions. Every developer, tester and analyst interview includes SQL.

🧪 2,90,000+ tests taken ⚡ Instant score 🆓 Completely free

Start the Free Test → See Sample Questions

How it works

Three steps between you and an honest score.

Open the testOne quick registration on our test portal — used by 2,90,000+ test attempts so far.

Answer the MCQsTopic-wise multiple-choice questions at fresher interview level.

Get your score instantlySee what you got right, where you are weak, and what to revise next.

What the test covers

Questions are written and reviewed by our trainers — the same topics interviewers test.

SELECT & WHEREJoins (INNER/LEFT/RIGHT)GROUP BY & HAVINGPrimary & foreign keysAggregate functionsSubqueriesINSERT/UPDATE/DELETEIndexes & constraints

Sample questions

A taste of the difficulty level — click a question to reveal the answer.

Q1. Which JOIN returns all rows from the left table, with NULLs where the right table has no match?Click to reveal answer ▾

A. INNER JOIN

B. LEFT JOIN ✓

C. RIGHT JOIN

D. CROSS JOIN

Why: LEFT JOIN keeps every left-table row; unmatched right-side columns come back as NULL. INNER JOIN keeps only matching rows — the most-tested SQL distinction in interviews.

Q2. Which clause filters rows AFTER grouping?Click to reveal answer ▾

A. WHERE

B. HAVING ✓

C. ORDER BY

D. LIMIT

Why: WHERE filters rows before grouping; HAVING filters the grouped results — so conditions on aggregates like COUNT(*) > 5 must go in HAVING.

Q3. What does COUNT(*) count, compared to COUNT(column)?Click to reveal answer ▾

A. They are always identical

B. COUNT(*) counts all rows; COUNT(column) skips NULLs in that column ✓

C. COUNT(*) is slower and deprecated

D. COUNT(column) includes NULLs

Why: COUNT(*) counts rows regardless of content; COUNT(column) ignores rows where that column is NULL — a difference that silently changes report numbers.

Q4. A primary key column can contain…Click to reveal answer ▾

A. Duplicate values

B. NULL values

C. Neither duplicates nor NULLs ✓

D. Both, if indexed

Why: A primary key uniquely identifies each row — uniqueness forbids duplicates and identification forbids NULL. A table can have only one primary key.

Q5. Which statement removes all rows but keeps the table structure, without logging individual row deletions?Click to reveal answer ▾

A. DELETE FROM t

B. DROP TABLE t

C. TRUNCATE TABLE t ✓

D. REMOVE TABLE t

Why: TRUNCATE empties the table fast and resets auto-increment; DELETE removes rows one by one (and can have WHERE); DROP deletes the table itself.

Who should take this test

Every IT fresher — Java, Python, testing or data: SQL questions appear in virtually every technical interview.
Data analyst aspirants — SQL is the single most-tested skill for analyst and MIS roles.
Testers preparing for QA interviews — database validation questions are standard in testing rounds; pair with our 42 testing interview questions.
Anyone whose course covered SQL months ago — joins rust fast; find out what you still remember.

Frequently asked questions

Is the SQL MCQ test really free?

Yes — completely free with instant scoring. Over 2,90,000 test attempts have been taken on our portal by students preparing for placements.

Do I need to create an account?

A quick one-time registration on the test portal is needed so your scores are saved and you can track improvement across attempts.

Is the test MySQL-specific or general SQL?

The questions use MySQL syntax — the database used in most Indian fresher job descriptions — but the concepts (joins, keys, grouping, aggregates) apply to any relational database.

How does this help my placement?

At The Kiran Academy, test performance is part of placement eligibility — our placement team uses test scores to certify students as interview-ready. For external users, it is an honest diagnostic of what to revise.