Exam 1z0-908 topic 1 question 80 discussion

Actual exam question from Oracle's 1z0-908

Question #: 80
Topic #: 1

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

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.

Show Suggested Answer

Suggested Answer: DE 🗳️

by Dhanushka at July 31, 2023, 4:08 p.m.

Submit Cancel

11 months, 1 week ago

AC, answers don't make sense

upvoted 1 times

9 months, 2 weeks ago

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

upvoted 1 times

7 months, 4 weeks ago

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

upvoted 1 times

...

1 year ago

Selected Answer: BD

Analyze table does not execute --auto-repair

upvoted 1 times

...