Which option is used in 'mysqldump' to make all tables in the destination databases to use a different storage engine?

Solution (By Examveda Team)

This question asks about a command-line option used with the 'mysqldump' tool in MySQL. 'mysqldump' is used to create backups of your database.

The options given are used to specify how the tables in your backup should be stored when you restore them to a new database.

We're looking for the option that lets you change the storage engine used for all the tables. Storage engines are like different ways MySQL can organize data within tables.

Of the options provided, only '-new-storage-engine' is designed to change the storage engine used for tables. It allows you to specify a new storage engine for all tables during the restoration process.

So the correct answer is Option B: -new-storage-engine.