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.)

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

Backup and Recovery

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.

How the community answered

(15 responses)

A
80% (12)
C
7% (1)
E
13% (2)

Explanation

https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_single-transaction

Topics

#mysqldump#--master-data#--single-transaction#consistent backup

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice