Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 80

You are using mysqlcheck for server maintenance.

Which two statements are true? (Choose two.)

    Correct Answer: A, B

    When using mysqlcheck for server maintenance, the mysqlcheck --check --all-databases command takes table write locks while performing a series of checks, ensuring data integrity during the maintenance process. Moreover, the mysqlcheck --optimize --all-databases command reclaims free space from table files by defragmenting the tables and optimizing their storage. These commands are part of common database maintenance tasks to ensure smooth operation and efficient storage management.

Discussion
marklv

AC, answers don't make sense

marklv

AD. B is not always going to free up space if the innodb tables use general tablespace. For check, there is a read lock.

marklv

B is not guarantied, innodb use general space won't free up. E might be the other right answer.

DhanushkaOptions: BD

Analyze table does not execute --auto-repair