Oracle MySQL 5 Database Administrator Certified Professional Set 3

BEGIN and ROLLBACK have an effect only for tables managed by transactional storage engines, such as
InnoDB. ✘ Some index types are available only for particular storage engines. For example, only the MyISAM enginesupports full-text or spatial indexes. ✘ LOAD DATA INFILE only works for tables managed by disk based storage engines, such as InnoDB orMyISAM. ✘ OPTIMIZE TABLE only works for tables managed by storage engines that perform table level locking, suchas MyISAM. ✔

The key buffer is used for caching index blocks for MyISAM tables. ✘ The key buffer is used for caching index blocks for all MySQL tables. ✘ Setting the buffer to a larger size will generally increase performance. ✘ Setting the buffer to a larger size will generally decrease performance. ✔

It is used to cache row data in open tables. ✘ It holds file descriptors for open tables. ✘ The size of the table cache may be set per-session ✘ Each connection has its own table cache. They are of equal size, set globally. ✔ There is one table cache, shared among all sessions. ✔

config.cnf ✘ config.ini ✘ my.cnf ✘ my.ini ✔ basedir.cnf ✔