Which two are true about binary logs used in asynchronous replication? (Choose two.)

• A.They are pushed from the master to the slave.
• B.They contain events that describe database changes on the master.
• C.They contain events that describe all queries run on the master.
• D.They contain events that describe only administrative commands run on the master.
• E.They are pulled from the master to the slave.

Comment: *

Name: *

Email: *

Verification: *

Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

• A.MEMORY
• B.NDB
• C.MyISAM
• D.InnoDB
• E.ARCHIVE

Comment: *

Name: *

Email: *

Verification: *

You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:

Which action would allow the server to start?

• A.Execute mysqladmin flush-logs.
• B.Create a new ib_logfile0 file of size 26214400.
• C.First run mysqld --initialize to refresh the Size of ib_logfile.
• D.Remove ib_logfile0 and ib_logfile1 files from the file system.

Comment: *

Name: *

Email: *

Verification: *

Which two MySQL Server accounts are locked by default? (Choose two.)

• A.any user set as DEFINER for stored programs
• B.any user created with a username, but missing the host name
• C.any user created without a password
• D.any new ROLE accounts
• E.any internal system accounts

Comment: *

Name: *

Email: *

Verification: *

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

• A.It executes flush tables with read lock.
• B.It enforces consistent backups for all storage engines.
• C.The backup created is a consistent data dump.
• D.This option uses the READ COMMITTED transaction isolation mode.
• E.It is a cold backup.

Comment: *

Name: *

Email: *

Verification: *