SQL Quiz Test Online (30 random Questions) 2026

This quick 30-minute challenge consists of 30 random multiple-choice questions designed to test your knowledge across various SQL topics, including the introduction to databases, data manipulation and querying, database design and normalization, advanced SQL concepts, and database administration and security. Whether you’re a beginner or looking to expand your SQL expertise, this quiz will enhance your understanding of database management and querying skills.

0 votes, 0 avg

337

You have 30 minutes to complete the quiz. The timer will start when you click the 'Start Quiz' button. Please ensure you are ready before beginning.

Time is up! Your quiz has ended. Your responses have been submitted automatically.

30 Minutes SQL Quiz Test Online

Welcome to the SQL Quiz! This quick 30-minute challenge consists of 30 random multiple-choice questions designed to test your knowledge across various SQL topics, including the introduction to databases, data manipulation and querying, database design and normalization, advanced SQL concepts, and database administration and security. Whether you're a beginner or looking to expand your SQL expertise, this quiz will enhance your understanding of database management and querying skills.

1 / 30

1. What is the purpose of using roles in database security?

A) To group permissions for easier management

B) To create backup strategies

C) To optimize query performance

D) To encrypt sensitive data

2 / 30

2. Which command is used to create a new table in a database?

A) INSERT

B) NEW TABLE

C) CREATE TABLE

D) ADD TABLE

3 / 30

3. Which normal form eliminates partial dependency?

A) 1NF

B) BCNF

C) 2NF

D) 3NF

4 / 30

4. What does the term 'role-based access control' (RBAC) mean?

A) Encrypting sensitive data

B) Assigning permissions to individual users

C) Granting access based on predefined roles

D) Backing up the database

5 / 30

5. How do you sort query results?

A) GROUP BY

B) ORDER BY

C) FILTER

D) SORT BY

6 / 30

6. Which command is used to remove a user in SQL?

A) DROP USER

B) ALTER USER

C) REMOVE USER

D) DELETE USER

7 / 30

7. What does ER stand for in ER Diagram?

A) External Resource

B) Entity Reference

C) Entity Relationship

D) Event Reaction

8 / 30

8. How does the SQL MERGE statement work?

A) Merges two tables into one new table

B) Combines columns from two queries into one result set

C) Optimizes indexes for faster retrieval

D) Performs insert, update, or delete operations based on a condition

9 / 30

9. What does the GROUP BY clause do?

A) Filters rows

B) Sorts rows

C) Deletes duplicate rows

D) Groups rows with the same values

10 / 30

10. What is the maximum number of primary keys a table can have?

A) Unlimited

B) None

C) 2

D) 1

11 / 30

11. What happens if a table is not normalized?

A) Elimination of relationships

B) Increased redundancy and anomalies

C) Reduced storage usage

D) Improved performance

12 / 30

12. What is a composite key?

A) A combination of two or more columns as a key

B) A single unique key

C) None of the above

D) A duplicate key

13 / 30

13. What is the purpose of the EXISTS clause in SQL?

A) To check if a table exists

B) To optimize queries

C) To verify the presence of rows in a subquery

D) To create a temporary table

14 / 30

14. What does the REVOKE command do?

A) Creates a backup of permissions

B) Removes permissions from a user

C) Deletes user accounts

D) Denies access to the database

15 / 30

15. What is the purpose of database auditing?

A) To track and log database activities

B) To optimize query performance

C) To encrypt database files

D) To design database schemas

16 / 30

16. What is the result of a CROSS JOIN?

A) Union of two tables

B) Cartesian product of two tables

C) Difference of two tables

D) Intersection of two tables

17 / 30

17. What does the IN operator do?

A) Matches a value within a set

B) Deletes rows

C) Sorts rows

D) Filters rows

18 / 30

18. How can user activity be restricted during maintenance?

A) By shutting down the database

B) By switching to read-only mode

C) By revoking all permissions

D) By locking the database

19 / 30

19. Which SQL keyword is used to sort the result set?

A) ORDER BY

B) FILTER

C) SORT

D) GROUP BY

20 / 30

20. How does the LAG() function work in SQL?

A) Returns the average value of a set

B) Returns the next value in a set

C) Computes a running total

D) Returns the previous value in a set

21 / 30

21. Which command is used to delete all rows from a table without removing the table?

A) REMOVE

B) DROP

C) TRUNCATE

D) DELETE

22 / 30

22. How do you remove a specific record from a table?

A) DROP

B) REMOVE

C) TRUNCATE

D) DELETE

23 / 30

23. What is functional dependency in a database?

A) A relationship between two tables

B) A relationship between two columns

C) A function that manages data

D) A dependency between primary keys

24 / 30

24. What is the default sorting order in SQL?

A) None

B) Ascending

C) Descending

D) Random

25 / 30

25. Which SQL command is used to grant permissions to a user?

A) ALLOW

B) PERMIT

C) GRANT

D) ASSIGN

26 / 30

26. What does the DISTINCT keyword do?

A) Sorts records

B) Deletes duplicate records

C) Filters records

D) Selects unique records

27 / 30

27. Which statement about stored procedures is true?

A) They are automatically optimized for performance by the database

B) They can be used to encapsulate complex SQL queries and business logic

C) They cannot accept input parameters

D) They are executed automatically on database startup

28 / 30

28. How is sensitive data protected in a database?

A) By auditing and monitoring activities

B) By limiting user access

C) By using encryption

D) All of the above

29 / 30

29. What does 'principle of least privilege' mean in database security?

A) Encrypting sensitive data

B) Removing unused tables and columns

C) Allowing all users full database access

D) Assigning minimum access necessary for users

30 / 30

30. What does SQL stand for?

A) Standard Query Language

B) Structured Query Language

C) Simple Query Language

D) Sequential Query Language

Your score is

The average score is 57%

Rate Your Experience!

Anonymous feedback

Thank you for your feedback! We appreciate your input.

10 Minutes JSON Quiz Test Online

10 Minutes Angular Quiz Test Online

Docker Quiz Test Online (30 random Questions)

10 Minutes JavaScript Quiz Test Online

10 Minutes Bootstrap Quiz Test Online

Online Quiz Test (with time limit)

Related