1Z0-873 無料問題集「MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part I」

（A）False

（B）True

（A）None of the above

（B）Stop the MySQL server

（C）Backup your databases

（D）Start the new server

（E）Check the MySQL Reference Manual upgrading section and read the parts that concern your upgrade

（F）Install the new version of MySQL on top of the existing version

（A）The server should be started with the mysqld_secure script.

（B）The data directory and it's contents should be strictly accessible only to the user MySQL runs as.

（C）All initial accounts should have passwords set and unused accounts should be removed.

（D）The MySQL server should be set to run as it's own user, not as an administrative account.

（A）Less work is required by the server to acquire and release locks.

（B）All tables must be locked in a single statement.

（C）It can only be used with the MyISAM storage engine.

（D）It creates more disk activity.

（E）Using LOCK TABLE sometimes decreases the amount disk reads and writes needed for a group of statements.

（A）INFORMATION_SCHEMA is a feature of standard SQL, and SHOW is a MySQL specific command.

（B）The information returned from the INFORMATION_SCHEMA can be stored in other tables.

（C）It is faster than using SHOW commands.

（D）Using the INFORMATION_SCHEMA can provide more concise information.

（E）You always use SELECT to retrieve any of the metadata.

（A）False

（B）True

（A）It stores its data in .MYD files, in the respective database directory, and its index and undo information in its own tablespace.

（B）It stores its data, index and undo information all in its own tablespace.

（C）It stores its data and index in .MYD and .MYI files, in the respective database directory, and undo information in its own tablespace.

（D）It stores its data, index and undo information in .MYD and .MYI files, in the respective database directory.

（A）It allows a transaction to see uncommitted changes made by other transactions.

（B）It allows a transaction to see committed changes made by other transactions.

（C）It allows a transaction to just see its committed changes.