Online Quiz Attempt – Play & Test Your Knowledge

Quizzes on Aggregate Functions

Read questions carefully before answering

Back to quizzes Help

⏱ 00:00

Dashboard
My Profile
Quiz Attempt
Logout

Question 1

1 / 10

Which isolation level in MySQL prevents dirty reads but allows non-repeatable reads?

READ UNCOMMITTED READ COMMITTED REPEATABLE READ SERIALIZABLE

Question 2

2 / 10

What is the purpose of the `EXPLAIN` statement in MySQL?

To execute a SQL query. To show the data returned by a SQL query. To analyze the execution plan of a SQL query. To create a new table.

Question 3

3 / 10

Which of the following is NOT a valid data type in MySQL?

INT VARCHAR BOOLEAN CHARACTER

Question 4

4 / 10

What is the primary use case for the `GROUP BY` clause in a SQL query?

To filter rows based on a condition. To sort the result set. To aggregate data based on one or more columns. To join two tables together.

Question 5

5 / 10

Which storage engine in MySQL is known for its transaction support and row-level locking?

MyISAM CSV InnoDB MEMORY

Question 6

6 / 10

What is the purpose of a foreign key constraint?

To ensure that a column contains only unique values. To define the primary key of a table. To enforce referential integrity between two tables. To specify the default value for a column.

Question 7

7 / 10

Which command is used to create a new user account in MySQL?

CREATE USER ADD USER NEW USER MAKE USER

Question 8

8 / 10

What is the function of the `AUTO_INCREMENT` attribute in MySQL?

To automatically increment a numeric value for each new row. To automatically create an index on a column. To automatically encrypt a column's data. To automatically validate the data entered into a column.

Question 9

9 / 10

Which SQL command is used to modify the structure of an existing table?

UPDATE TABLE CHANGE TABLE ALTER TABLE MODIFY TABLE

Question 10

10 / 10

What is the default port number used by MySQL server?

3306 8080 27017 5432

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