Online Quiz Attempt – Play & Test Your Knowledge

Questions on MySQL Triggers

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 provides the highest level of data consistency but can significantly reduce concurrency?

READ UNCOMMITTED READ COMMITTED REPEATABLE READ SERIALIZABLE

Question 2

2 / 10

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

To execute a stored procedure To display table schema information To analyze the query execution plan To create a new index

Question 3

3 / 10

Which MySQL storage engine is known for its transactional support, row-level locking, and foreign key constraints?

MyISAM CSV MEMORY InnoDB

Question 4

4 / 10

What function is used to calculate the MD5 hash of a string in MySQL?

SHA1() ENCRYPT() MD5() PASSWORD()

Question 5

5 / 10

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

To automatically index the column To automatically encrypt the column To automatically generate a unique sequential integer for the column To automatically validate the column's data type

Question 6

6 / 10

Which command is used to back up a MySQL database?

mysql_dump mysqlbackup mysqldump backup_mysql

Question 7

7 / 10

What is the difference between `VARCHAR` and `TEXT` data types in MySQL?

VARCHAR is fixed-length, TEXT is variable-length VARCHAR has a maximum length limit, TEXT does not VARCHAR stores numeric data, TEXT stores character data TEXT is indexed by default, VARCHAR is not

Question 8

8 / 10

Which clause is used to filter data based on a pattern in MySQL?

WHERE LIKE HAVING MATCH

Question 9

9 / 10

Which function is used to get the current date and time in MySQL?

CURDATE() CURTIME() NOW() TODAY()

Question 10

10 / 10

What is the primary key's primary function in a relational database like MySQL?

To store a description of the table To uniquely identify each record in a table To encrypt the data within the table To define the table's structure

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