1Z1-888 Exam Question 6
You have a MySQL instance with the following variables in the /etc/my.cnf file:
You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)
You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)
1Z1-888 Exam Question 7
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?
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?
1Z1-888 Exam Question 8
Consider the CHECK TABLEcommand.
In which two situations should this command be used? (Choose two.)
In which two situations should this command be used? (Choose two.)
1Z1-888 Exam Question 9
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?
1Z1-888 Exam Question 10
Exhibit:
What does the possible_keys column in this output denote?
What does the possible_keys column in this output denote?