MySQL 8.0 Database Administrator — Question 33

You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

Answer options

• A. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
• B. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
• C. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
• D. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
• E. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

Correct answer: D, E

Explanation

Option D is correct as mysqlcheck can be renamed to mysqlrepair for default repair functionality. Option E is also correct as the --analyze command does check for table corruptions. Options A, B, and C are incorrect because mysqlcheck does not take write locks during checks, does not reclaim space with optimize in that manner, and cannot repair InnoDB tables with the repair command.