You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)

• A.CREATE USER WITH sha256_password 'sha256_user'@'192.0.2.10' IDENTIFIED AS 'webdesign' USING 'imbatman';
• B.CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';
• C.CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password
  'imbatman';
• D.CREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
  'imbatman';
• E.CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY 'imbatman';
• F.CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';

Comment: *

Name: *

Email: *

Verification: *

Consider these global status variables:

Which two conclusions can be made from the output?

• A.There are 140 Performance Schema threads at the time of the output.
• B.There are 510 connections to MySQL at the time of the output.
• C.There are more connections being idle than executing queries.
• D.The thread cache has been configured with thread_cache_sizeset to at least 6.
• E.All max_connectionswere in use at 2018-03-22 14:54:06

Comment: *

Name: *

Email: *

Verification: *

You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

• A.--single-transaction
• B.--quick
• C.--skip-buffer
• D.--tab

Comment: *

Name: *

Email: *

Verification: *

Examine the mydata table and SELECT statements:

You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?

• A.five
• B.one row and a gap-lock
• C.one
• D.one row and a next-key lock for supremum

Comment: *

Name: *

Email: *

Verification: *

The MySQL instance is a default RPM installation on a Linux server.
Where are the errors written?

• A.in the /var/lib/mysql/hostname.log file
• B.no logging enabled by default
• C.in the /var/log/mysqld.err file
• D.in the syslog daemon on the server

Comment: *

Name: *

Email: *

Verification: *