Practice Questions

Which MySQL component is responsible for transaction support and crash recovery?

A. MyISAM B. C. D. B. InnoDB C. MEMORY D. ARCHIVE

What does GTID stand for in MySQL replication?

A. Global Transaction Identifier B. General Table Index Descriptor C. Global Table Integration Data D. Generated Transaction Index

Which command is used to create a logical backup?

A. mysqlbackup B. mysqldump C. mysqlpump D. backupdb

Which log helps identify slow-performing queries?

A. Error Log B. Binary Log C. Slow Query Log D. Relay Log

What is the default authentication plugin in MySQL 8.0?

A. mysql_native_password B. sha256_password C. caching_sha2_password D. auth_socket

Which tool is used to manage InnoDB Cluster?

A. MySQL Workbench B. MySQL Shell C. MySQL Admin D. MySQL Monitor