Exit 1Z0-873 MySQL 5.0 Database Administrator Certified Professional Exam, Part I
Question 1 of 5
0% complete
Q1 Multiple choice

Which of the following SQL constructs are not available with all storage engines, i.e.
which are storage engine dependent?

Select all that apply.

  • A

    BEGIN and ROLLBACK have an effect only for tables managed by transactional storage engines, such as InnoDB.

  • B

    Some index types are available only for particular storage engines. For example, only the MyISAM engine supports full-text or spatial indexes.

  • C

    LOAD DATA INFILE only works for tables managed by disk based storage engines, such as InnoDB or MyISAM.

  • D

    OPTIMIZE TABLE only works for tables managed by storage engines that perform table level locking, such as MyISAM.

Previous Next