Question 101

Which two statements are true about InnoDB auto-increment locking? (Choose two.)
  • Question 102

    At which stage during query processing does MySQL create a query's execution plan?
  • Question 103

    What is the order of tables shown in an EXPLAIN output?
  • Question 104

    You are using replication and the binary log files on your master server consume a lot of disk space.
    Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)