Demo Questions:
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...
