Home/ Questions/Q 352154
Next
In Process
Radheshyam Darpan Ravi
Asked: 2022-11-02T11:15:46+05:30 In:

For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

(a) –multiple-transaction

(b) –single-transaction

(c) –double-transaction

(d) –no-transaction

For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

(a) –multiple-transaction

(b) –single-transaction

(c) –double-transaction

(d) –no-transaction
Social
Leave an answer

Leave an answer

Browse

1 Answer

  1. The correct 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.

    • 0
Nikita Handa
Asked: 2022-11-01T17:08:58+05:30 In:

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

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
Social
Leave an answer

Leave an answer

Browse

1 Answer

  1. 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.

    • 0