1Z0-873 · Question #88
Which of the following is true for the command-line programs mysqlcheck and myisamchk?
The correct answer is B. mysqlcheck can perform checks and repairs on a remote server, and myisamchk must run on the. The myisamchk utility for MyISAM tables also performs table maintenance. However, it takes a different approach from MySQL Administrator and mysqlcheck. Rather than sending SQL statements to the server, myisamchk directly reads and modified the table files. For this reason…
Question
Which of the following is true for the command-line programs mysqlcheck and myisamchk?
Options
- Amysqlcheck must run on the server to perform checks and repairs and myisamchk can perform
- Bmysqlcheck can perform checks and repairs on a remote server, and myisamchk must run on the
- CBoth mysqlcheck and myisamchk can perform checks and repairs on a remote server.
- DNeither mysqlcheck or myisamchk can perform checks and repairs on a remote server.
How the community answered
(26 responses)- A4% (1)
- B77% (20)
- C12% (3)
- D8% (2)
Explanation
The myisamchk utility for MyISAM tables also performs table maintenance. However, it takes a different approach from MySQL Administrator and mysqlcheck. Rather than sending SQL statements to the server, myisamchk directly reads and modified the table files. For this reason, it's necessary when using myisamchk to ensure that the server does not access the tables at the
Topics
Community Discussion
No community discussion yet for this question.