You are using GTIDS in replication. You need to skip a transaction with the GTID of aaa-bbb-ccc-ddd-eee:3 on a slave.
Which procedure would you execute from a MySQL prompt?

• A.Option A
• B.Option D
• C.Option C
• D.Option B

Comment: *

Name: *

Email: *

Verification: *

You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)

• A.Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
• B.Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
• C.Start the MySQL Server with --init-filepointing to SQL that executes an ALTER USER statement to change the root user password.
• D.Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
• E.Start the MySQL Server with -initialize-insecureto force a password reset procedure on the command line.

Comment: *

Name: *

Email: *

Verification: *

Where does MySQL Linux RPM install the mysqld binary?

• A./usr/libexec/
• B./usr/local/mysql/bin/
• C./usr/sbin/
• D./usr/bin/
• E./opt/mysql/server/bin/

Comment: *

Name: *

Email: *

Verification: *

You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?

• A.Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
• B.Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
• C.Start the MySQL Server with --init-filepointing to SQL that executes an ALTER USER statement to change the root user password.
• D.Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
• E.Start the MySQL Server with -initialize-insecureto force a password reset procedure on the command line.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

• A.Physical backups can be used to recover from data corruption.
• B.Logical backups are always larger than physical backups.
• C.Physical backups are usually faster than text backups.
• D.Logical backups are human-readable whereas physical backups are not.
• E.Physical backups are usually slower than text backups.

Comment: *

Name: *

Email: *

Verification: *