Database and SQL Mock Test – Free Online Quiz V1.0

Hurry up, Your quiz is started!

Thank you! If you like share your experience and knowledge with the world.

Database and SQL Mock Test – Free Online Assessment Version 1.0

Database and SQL mock test v1.0 with 50 multiple choice questions for practice

The Database & SQL Mock Test v1.0 is a beginner-to-intermediate level practice quiz designed to help learners test and strengthen their understanding of database fundamentals and Structured Query Language (SQL).

This version focuses on core database concepts and essential SQL commands that are commonly expected from students, fresh graduates, and entry-level IT professionals working with data-driven applications and systems.

The quiz includes 50 carefully selected multiple-choice questions that evaluate both conceptual understanding and basic practical SQL knowledge. Future versions will expand into advanced SQL queries, optimization techniques, and real-world database scenarios.

What This Version Covers

Database fundamentals and DBMS concepts
Difference between DBMS and RDBMS
Tables, rows, columns, and database keys
SQL basics such as SELECT, WHERE, and ORDER BY
Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
Primary keys and foreign keys
Joins and table relationships
Database normalization basics
Indexes, views, and transactions
ACID properties and basic database security concepts

Quiz Features

📝 50 database and SQL multiple-choice questions
⏱️ Time-based test environment
📊 Instant score and result evaluation
🔁 Retake option for repeated practice
🎯 Designed for beginners and early-career professionals

Who Should Take This Test?

Students learning databases and SQL fundamentals
Fresh graduates preparing for technical interviews
Entry-level developers and database learners
IT professionals revising core SQL concepts
Anyone aiming to build a strong foundation in databases

Version Information

Current Version: 1.0
Level: Beginner to Intermediate
Future Updates: Advanced SQL queries, subqueries, stored procedures, performance tuning, and detailed analytics

💡 This quiz is designed as a practical learning and assessment tool. Repeating the test will help users improve SQL accuracy, confidence, and readiness for real-world database tasks.

1 / 50

Q50. Which JOIN returns all records from both tables?

A. INNER JOIN

B. LEFT JOIN

C. RIGHT JOIN

D. FULL JOIN

2 / 50

Q49. Which JOIN returns all records from left table?

A. INNER

B. LEFT JOIN

C. RIGHT JOIN

D. FULL JOIN

3 / 50

Q48. Which JOIN returns matching records only?

A. LEFT JOIN

B. RIGHT JOIN

C. FULL JOIN

D. INNER JOIN

4 / 50

Q47. Which SQL keyword joins tables?

A. MERGE

B. JOIN

C. LINK

D. UNION

5 / 50

Q46. Which command removes permissions?

A. DENY

B. BLOCK

C. REVOKE

D. REMOVE

6 / 50

Q45. Which command grants permissions?

A. ALLOW

B. GRANT

C. GIVE

D. SHARE

7 / 50

Q44. Which operator checks a range?

A. LIKE

B. IN

C. BETWEEN

D. RANGE

8 / 50

Q43. Which operator checks multiple values?

A. BETWEEN

B. LIKE

C. IN

D. IS

9 / 50

Q42. Which SQL keyword combines conditions?

A. JOIN

B. AND

C. LINK

D. MATCH

10 / 50

Q41. Which ACID property ensures rollback on failure?

A. Atomicity

B. Consistency

C. Isolation

D. Atomicity

11 / 50

Q40. ACID property ensures:

A. Speed

B. Reliable transactions

C. Encryption

D. Compression

12 / 50

Q39. Which database is open-source?

A. Oracle

B. SQL Server

C. MySQL

D. DB2

13 / 50

Q38. Which SQL command removes all rows but keeps structure?

A. DELETE

B. DROP

C. TRUNCATE

D. CLEAR

14 / 50

Q37. Which command renames a table?

A. UPDATE

B. CHANGE

C. ALTER TABLE

D. MODIFY

15 / 50

Q36. What is a view?

A. Physical table

B. Virtual table based on query

C. Backup file

D. Index

16 / 50

Q35. Which SQL keyword limits result rows?

A. STOP

B. END

C. LIMIT

D. TOP

17 / 50

Q34. What is an index used for?

A. Backup tables

B. Encrypt data

C. Improve query performance

D. Store images

18 / 50

Q33. What is redundancy?

A. Data security

B. Duplicate data

C. Data encryption

D. Data indexing

19 / 50

Q32. First Normal Form (1NF) requires:

A. Multiple values in a field

B. Atomic values

C. Duplicate records

D. No primary key

20 / 50

Q31. What is normalization?

A. Increasing data size

B. Reducing data redundancy

C. Encrypting data

D. Formatting tables

21 / 50

Q30. Which clause filters grouped data?

A. WHERE

B. HAVING

C. FILTER

D. LIMIT

22 / 50

Q29. Which SQL clause groups rows with same values?

A. SORT

B. FILTER

C. GROUP BY

D. ORDER BY

23 / 50

Q28. Which data type stores whole numbers?

A. CHAR

B. INT

C. TEXT

D. DATE

24 / 50

Q27. Which data type stores text?

A. INT

B. FLOAT

C. DATE

D. VARCHAR

25 / 50

Q26. What is a foreign key?

A. A key used for encryption

B. A field linking two tables

C. A backup key

D. A primary key duplicate

26 / 50

Q25. A primary key can contain:

A. NULL values

B. Duplicate values

C. Only unique and non-NULL values

D. Text only

27 / 50

Q24. What is a primary key?

A. Duplicate value

B. Foreign value

C. Unique identifier for records

D. Optional column

28 / 50

Q23. Which SQL statement removes a table completely?

A. DELETE

B. TRUNCATE

C. DROP

D. REMOVE

29 / 50

Q22. Which command creates a new table?

A. ADD TABLE

B. CREATE TABLE

C. NEW TABLE

D. INSERT TABLE

30 / 50

Q21. Which SQL function returns the lowest value?

A. LOW()

B. MIN()

C. SMALL()

D. LESS()

31 / 50

Q20. Which SQL function returns the highest value?

A. TOP()

B. HIGH()

C. MAX()

D. UPPER()

32 / 50

Q19. Which function is used to count records?

A. SUM()

B. AVG()

C. COUNT()

D. TOTAL()

33 / 50

Q18. Which SQL keyword is used to select unique values?

A. UNIQUE

B. DUPLICATE

C. ONLY

D. DISTINCT

34 / 50

Q17. What does NULL represent in SQL?

A. Zero

B. Empty string

C. Unknown or missing value

D. False

35 / 50

Q16. Which clause is used to sort query results?

A. SORT

B. ORDER BY

C. GROUP BY

D. ALIGN

36 / 50

Q15. Which SQL command removes records from a table?

A. DROP

B. REMOVE

C. DELETE

D. TRUNCATE

37 / 50

Q14. Which SQL command modifies existing data?

A. INSERT

B. CREATE

C. UPDATE

D. ALTER

38 / 50

Q13. Which SQL statement adds new data into a table?

A. ADD

B. INSERT

C. CREATE

D. SELECT

39 / 50

Q12. Which symbol is used for wildcard matching in SQL?

A. #

B. *

C. %

D. &

40 / 50

Q11. Which SQL clause is used to filter records?

A. GROUP BY

B. ORDER BY

C. WHERE

D. HAVING

41 / 50

Q10. Which SQL command is used to retrieve data?

A. INSERT

B. DELETE

C. UPDATE

D. SELECT

42 / 50

Q9. Each column in a table represents a:

A. Record

B. Field

C. File

D. Database

43 / 50

Q8. Each row in a table is also called a:

A. Field

B. Column

C. Record

D. Cell

44 / 50

Q7. A table in a database consists of:

A. Files and folders

B. Rows and columns

C. Objects and classes

D. Forms and reports

45 / 50

Q6. Which of the following is a relational database?

A. MongoDB

B. Redis

C. Cassandra

D. MySQL

46 / 50

Q5. What does SQL stand for?

A. Structured Question Language

B. Simple Query Language

C. Structured Query Language

D. Sequential Query Language

47 / 50

Q4. Which language is used to interact with relational databases?

A. HTML

B. CSS

C. JavaScript

SQL

48 / 50

Q3. What is a database primarily used for?

A. Playing games

B. Creating graphics

C. Storing and managing data

D. Sending emails

49 / 50

Q2. Which of the following is an example of a database?

A. Text file

B. Spreadsheet

C. MySQL database

D. Image file

50 / 50

Q1. What does DBMS stand for?

A. Data Backup Management System

B. Database Management System

C. Data Base Machine Software

D. Digital Business Management System

Your score is

The average score is 0%