QUESTION: 1
You back up by using mysqldump. Which configuration is required on the MySQL
Server to allow point-in-time recovery?
A. binlog_format=STATEMENT
B. log-bin
C. apply-log
D. bonlog_format=ROW
E. gtid_enable
Answer: B
QUESTION: 2
Consider that local disk files are accessible via MySQL with commands such as: mysql>
LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords; What
change could be made to stop any breach via this insecurity?
A. executing REVOKE LOAD FROM *.*
B. setting the --local-service=0 option when starting mysqld
C. executing REVOKE FILE FROM *_*
D. executing REVOKE FILE ON *_* FROM ‘ ‘@’%’
E. setting the --local-infile=0 option when starting mysqld
F. setting the --open-files-limit=0 option when starting mysqld
Answer: F
QUESTION: 3
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
A. CREATE USER ‘webdesign’@’192.0.2.10’ IDENTIFIED AS sha256_user WITH
sha256_password ‘imbatman’;
B. CREATE USER ‘webdesign’@’192.0.2.10’ IDENTIFIED BY ‘iambatman’;
C. CREATE USER ‘webdesign’@’192.0.2.10’ IDENTIFIED WITH sha256_password
BY ‘imbatman’;
D. CREATE USER WITH sha256_password ‘sha256_user’@’192.0.2.10’
IDENTIFIED AS ‘webdesign’ USING ‘imbatman’;
E. CREATE USER ‘webdesign’@’192.0.2.10’ WITH mysql_native_password USING
SHA265 BY ‘imbatman’;
F. CREATE USER ‘webdesign’@’192.0.2.10’ IDENTIFIED BY SHA265 AS
‘imbatman’;
Answer: B, F
QUESTION: 4
One of your colleagues is trying to make a change using the mysql command-line client
for his or her application session. The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200; Why does the command fail?
A. max_connections requires the GLOBAL scope.
B. Its current user does not have the SUPER privilege.
C. max_connections is not a dynamic variable. You need to change the config file and
restart the database.
D. Users can control only the max_user_connections variable.
Answer: A
QUESTION: 5
You have installed MySQL Server for the first time on your system. However, the data
directory along with the tables in the mysql system database are missing. Which step do
you perform to create the contents of the data directory?
A. Run the create_system_tables.sql file
B. Run the mysql_unpack.sql file
C. Invoke mysqld with the --initialize option.
D. Invoke mysql with the --initialize option.
Answer: C
