Question: 1
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: 2
Which two statements are true about InnoDB auto-increment locking? (Choose two.)
A. InnoDB never uses table-level locks.
B. InnoDB always protects auto-increment updates with a table-level lock
C. InnoDB does not use locks to enforce auto-increment uniqueness.
D. The auto-increment lock can be a table-level lock.
E. Some settings for innodb_autoinc_lock_mode can help reduce locking.
Answer: D E
Question: 3
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration: The MySQL Server is restarted without error.What effect will the new configuration have on existing account?
A. They are not affected by this configuration change.
B. They all connect via the secure sha256_password algorithm without any configuration
change.
C. They will have their passwords updated on start-up to sha256_password format.
D. They will have to change their password the next time they login to the server.
Answer: A
Question: 4
Which three options are most likely to be changed for production form their default values?
(Choose three.)
A. innodb_buffer_pool_size
B. max_connections
C. join_buffer_size
D. character_set_system
E. innodb_log_file_size
F. max_user_connections
G. port
Answer: E F G
Question: 5
You back up by using mysql dump.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
For More Info:
