Exit 1Z0-908 MySQL 8.0 Database Administrator
Question 2 of 5
0% complete
Q2 Single choice

t is a non-empty InnoDB table.

Examine these statements, which are executed in one session:

BEGIN;

SELECT * FROM t FOR UPDATE;

Which is true?

  • A

    If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.

  • B

    If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the
    status.

  • C

    mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.

  • D

    If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or
    rolled back.

Previous Next