Oracle
1Z0-908 · Question #63
1Z0-908 Question #63: Real Exam Question with Answer & Explanation
The correct answer is A. It executes flush tables with read lock. D. This option uses the READ COMMITTED transaction isolation mode.. https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_single-transaction
Question
Examine this command, which executes successfully: shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)
Options
- AIt executes flush tables with read lock.
- BIt enforces consistent backups for all storage engines.
- CThe backup created is a consistent data dump.
- DThis option uses the READ COMMITTED transaction isolation mode.
- EIt is a cold backup.
Explanation
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_single-transaction
Community Discussion
No community discussion yet for this question.