Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

• A.QN = 4
• B.QN = 2
• C.QN = 1
• D.QN = 5
• E.QN = 3

Comment: *

Name: *

Email: *

Verification: *

Examine this list of MySQL data directory binary logs:
binlog.000001
binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)

• A.All databases are backed up to the output file.
• B.All non-active binary logs are removed from the master.
• C.All binary logs are backed up and then deleted.
• D.All databases, excluding master metadata, are backed up to the output file.
• E.All binary logs are deleted from the master.
• F.All details regarding deleted logs and master metadata are captured in the output file.

Comment: *

Name: *

Email: *

Verification: *

You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?

• A.Use mysql_secure_installation to encrypt stored login credentials.
• B.Use a text editor to create a new defaults file and encrypt it from Linux prompt.
• C.Use the AES_ENCRYPT() MySQL function on the option file.
• D.Use mysql_config_editor to create an encrypted file.

Comment: *

Name: *

Email: *

Verification: *

Examine this query:

What information does this query provide?

• A.total memory used across all connections associated with the user on connection number 10
• B.total memory used by the first 10 threads
• C.total memory used by thread number 10
• D.total memory used by connection number 10
• E.total memory used across all connections associated with the user on thread number 10
• F.total memory used by the first 10 connections

Comment: *

Name: *

Email: *

Verification: *

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

• A.GRANT UPDATE ON 'world'.* TO 'tom'@'%';
  GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';
• B.GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
  GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';
• C.GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
• D.GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
  'tom'@'%';

Comment: *

Name: *

Email: *

Verification: *