Question

Which option suppresses output unless there are errors in the table?

(a) –silent

(b) –wild

(c) –suppress

(d) –noout

The question was asked in an internship interview.

This interesting question is from General Preventative Maintenance topic in section Database Maintenance, Backups and Replication of MySQL

Answer 1

Correct choice is (a) –silent

Best explanation: In MySQL, the ‘–silent’ option suppresses the output unless there are errors in the tables. The ‘cron’ jobs typically generate a mail message if a job produces any output at all.