Online Quiz Attempt – Play & Test Your Knowledge

Questions on SELECT Statement

Read questions carefully before answering

Back to quizzes Help

⏱ 00:00

Dashboard
My Profile
Quiz Attempt
Logout

Question 1

1 / 10

Which storage engine is the default in MySQL 8.0 and later?

MyISAM InnoDB MEMORY NDB Cluster

Question 2

2 / 10

Which SQL statement is used to add a new column to an existing table?

ADD COLUMN INSERT COLUMN ALTER TABLE ADD COLUMN CREATE COLUMN

Question 3

3 / 10

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

To automatically update a timestamp column. To automatically generate unique IDs for a column. To automatically encrypt the column's data. To automatically index the column.

Question 4

4 / 10

Which keyword is used to retrieve only distinct values from a column in a SELECT statement?

UNIQUE DISTINCT GROUP BY UNIQUE VALUES

Question 5

5 / 10

What is the function of the `FOREIGN KEY` constraint?

To ensure data integrity by enforcing relationships between tables. To limit the maximum length of a column's value. To automatically index a column. To prevent duplicate values in a column.

Question 6

6 / 10

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

INT VARCHAR BOOLEAN IMAGE

Question 7

7 / 10

Which command is used to display the structure of a table?

SHOW TABLE DESCRIBE DISPLAY TABLE TABLE INFO

Question 8

8 / 10

What is the purpose of the `GROUP BY` clause in a SELECT statement?

To sort the result set in ascending order. To filter the result set based on a condition. To group rows with the same values in specified columns into summary rows. To limit the number of rows returned.

Question 9

9 / 10

Which isolation level offers the highest degree of protection against concurrency issues but may impact performance?

READ UNCOMMITTED READ COMMITTED REPEATABLE READ SERIALIZABLE

Question 10

10 / 10

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

To execute a query and return the result set. To show the execution plan of a query. To encrypt the query before execution. To optimize the query for faster performance.

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