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
Answer: Option B
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network

Join The Discussion