Given these table definitions and the explain plan:

Which ALTER TABLE statement will improve the performance of the query?

• A.ALTER TABLE `Country` ADD INDEX `idx_Code` (`Code`);
• B.ALTER TABLE `CountryLanguage` ADD INDEX `idx_Lang` (`Language`);
• C.ALTER TABLE `CountryLanguage` ADD INDEX `idx_OffLang` (`IsOfficial`, `Language`);
• D.ALTER TABLE `Country` ADD INDEX `idx_NameCont` (`Name`, `CountryCode`);

Comment: *

Name: *

Email: *

Verification: *

You have just created a replication slave from a backup of the master made with mysqldump:

You try to log in to the slave with the application user, but fail as follows:

The login works on the master.
Which two changes to the process can fix the issue?

• A.Use the -grants option to include GRANT statements in the dump.
• B.Add a second dump for the `mysql' database; --all-databases does not include it.
• C.Use the -flush-privileges with mysqldump.
• D.After the restore, log in to the database and execute FLUSH PRIVILEGES.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about InnoDB auto-increment locking? (Choose two.)

• A.InnoDB always protects auto-increment updates with a table-level lock
• B.The auto-increment lock can be a table-level lock.
• C.InnoDB never uses table-level locks.
• D.Some settings for innodb_autoinc_lock_mode can help reduce locking.
• E.InnoDB does not use locks to enforce auto-increment uniqueness.

Comment: *

Name: *

Email: *

Verification: *

Which three tasks are handled by the optimizer? (Choose three.)

• A.Change the order in which the tables are joined.
• B.Execute the query.
• C.Decide which indexes to use.
• D.Verify that the user is allowed to execute the query.
• E.Parse the query.
• F.Validate the query.
• G.Rewrite the WHEREclause.

Comment: *

Name: *

Email: *

Verification: *

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a
.mylogin.cnf file.
Which two are true about the login path feature? (Choose two.)

• A.It is an alternative to storing the MySQL login details in a my.cnf file.
• B.mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.
• C.It provides means to help avoid accidentally exposing the MySQL login details.
• D.It provides a FIPS-compliant keyring for storing MySQL login details.
• E.A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
• F.A .mylogin.cnf file can store at most one login path.

Comment: *

Name: *

Email: *

Verification: *