📊 MySQL
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
💬 Discuss
✅ Correct Answer: (B) -single-transaction

Explanation: 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.

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.

💬 Discussion

📊 Question Analytics

👁️
84
Total Visits
📽️
12 mo ago
Published
🎖️
Neelam Mittal
Publisher
📈
89%
Success Rate