1.

For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______________(a) –multiple-transaction(b) –single-transaction(c) –double-transaction(d) –no-transaction

Answer» Right answer is (b) –single-transaction

Explanation: For InnoDB tables it is possible to perform an online backup that takes no locks on tables using the option ‘–single-transaction’ to ‘mysqldump’. The ‘mysqldump’ can make backups.


Discussion

No Comment Found

Related InterviewSolutions