Online Quiz Attempt – Play & Test Your Knowledge

Questions on SQL Basics

Read questions carefully before answering

⏱ 00:00

Dashboard
My Profile
Quiz Attempt
Logout

Question 1

1 / 10

Which isolation level in MySQL provides the highest level of protection against concurrency issues like dirty reads and phantom reads, but can significantly impact performance?

READ COMMITTED READ UNCOMMITTED REPEATABLE READ SERIALIZABLE

Question 2

2 / 10

What is the primary function of the `EXPLAIN` statement in MySQL?

To display the table schemas. To execute a query and show the results. To analyze the execution plan of a query. To create a new database connection.

Question 3

3 / 10

Which storage engine in MySQL is known for its transactional support and row-level locking, providing better concurrency?

MyISAM CSV InnoDB MEMORY

Question 4

4 / 10

What does ACID stand for in the context of database transactions?

Atomicity, Consistency, Isolation, Durability Availability, Consistency, Integrity, Durability Atomicity, Control, Integrity, Distribution Availability, Control, Isolation, Distribution

Question 5

5 / 10

Which data type is most suitable for storing JSON documents in MySQL 5.7+?

TEXT BLOB VARCHAR JSON

Question 6

6 / 10

What is the purpose of the `AUTO_INCREMENT` attribute when defining a column in a MySQL table?

To automatically encrypt the column data. To automatically generate a unique sequence of integers for the column. To automatically index the column. To automatically validate the data type of the column.

Question 7

7 / 10

Which command is used to grant privileges to a user in MySQL?

CREATE USER ALTER USER GRANT REVOKE

Question 8

8 / 10

What is the default port number used by MySQL server?

3305 3307 3306 3308

Question 9

9 / 10

Which function is used to calculate the number of rows that match a specific criteria in a MySQL table?

SUM() AVG() MAX() COUNT()

Question 10

10 / 10

Which of the following is NOT a valid clause in a `SELECT` statement?

WHERE ORDER BY GROUP BY CONNECT BY

Total Questions : 10

Answered Marked Not Visited

Instructions: Navigation between questions is allowed. Only selected answers will be saved.

💾 All answers are auto-saved • Do not refresh or close the page