Questions on SQL Basics

Read carefully before answering

← Back Help

⏱ 00:00

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

Answered

Marked

Not Visited

Instructions:
Navigation between questions is allowed. Your answers are auto-saved instantly.

🔒 Secure Session •

⚠ Do not refresh page