Questions on MySQL Triggers

Read carefully before answering

← Back Help

⏱ 00:00

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

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

Answered

Marked

Not Visited

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

🔒 Secure Session •

⚠ Do not refresh page