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.

Published by Neelam Mittal ⭐ 4.57K Points at 22-Mar-2025 12:45 pm in 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.

💬 Discussion

📊 Question Analytics

👁️
99
Total Visits
📽️
1 y ago
Published
🎖️
Neelam Mittal
Publisher
📈
90%
Success Rate