N

Neelam Mittal • 4.57K Points
Extraordinary

Q. 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
  • Correct Answer - Option(B)
  • Views: 15
  • Filed under category MySQL
Explanation by: Neelam Mittal 
This question is about taking a backup of your MySQL database without disrupting the normal operations. We want to ensure that the backup process doesn't interfere with users accessing or modifying data.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Question analytics