1Z0-888 Exam Question 71

Consider the index information for the dept_emp table in the employee's schema:

Which two conclusions can be made based on the output of the query? (Choose two.)
  • 1Z0-888 Exam Question 72

    What is the order of tables shown in an EXPLAIN output?
  • 1Z0-888 Exam Question 73

    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.)
  • 1Z0-888 Exam Question 74

    A crucial database, 'db_prod', just disappeared from your production MySQL instance.
    In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
    SELECT id FROM users WHERE login='payback!';DROP DATABASE db_prod;'
    Which three methods could have been used to prevent this SQL injection attack from happening?
  • 1Z0-888 Exam Question 75

    Consider the index information for the dept_emptable in the employee's schema:

    Which two conclusions can be made based on the output of the query? (Choose two.)