Quiz-summary
0 of 5 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
Information
Start your database journey with the Free SQL Basic Practice Quiz on Quizsm. This practice zone is designed for beginners who want to build a strong foundation in SQL through structured and interactive quizzes—completely free of cost.
The quizzes cover fundamental SQL topics such as basic queries, SELECT statements, filtering with WHERE, sorting using ORDER BY, simple joins, data types, and basic database concepts. With a mix of multiple-choice and true/false questions, this practice zone helps you understand core concepts and apply them in simple real-world scenarios.
With unlimited free access, you can attempt quizzes multiple times, identify your weak areas, and improve your understanding through continuous self-assessment. This approach ensures that you gain confidence in writing basic SQL queries and understanding how databases work.
The Free SQL Basic Practice Quiz is the perfect starting point for students, beginners, and anyone new to databases. Begin your SQL learning journey today and build a strong foundation with Quizsm.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 5 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- Answered
- Review
-
Question 1 of 5
1. Question
Consider the query:
SELECT * FROM employees WHERE dept_id NOT IN (10, 20, NULL);What will this query return?
Correct
Incorrect
-
Question 2 of 5
2. Question
What will happen when this query is executed?
SELECT salary * 12 AS annual_salary FROM employees WHERE annual_salary > 600000;Correct
Incorrect
-
Question 3 of 5
3. Question
What is the result of the following query?
SELECT COUNT(*) FROM employees GROUP BY dept_id ORDER BY COUNT(*) DESC LIMIT 1;Correct
Incorrect
-
Question 4 of 5
4. Question
Consider the following transaction:
START TRANSACTION; TRUNCATE TABLE employees; ROLLBACK;What will be the final state of the employees table in most SQL databases?
Correct
Incorrect
-
Question 5 of 5
5. Question
Consider the query:
SELECT name, salary, dept_id FROM employees ORDER BY 2 DESC;What does ORDER BY 2 refer to?
Correct
Incorrect

