BunnKou123 BunnKou123
关注数: 5 粉丝数: 146 发帖数: 458 关注贴吧数: 9
咨询几道题目,请大神帮忙解答下 1. Which two statements are true about a table cache in MySQL? A. A global table cache is used for all open tables. B. A separate table cache is used for data in each open table. C. A table cache is used to cache frequently used table indexes. D. A table cache is used to cache the status of individual tables. E. A table cache is used to cache open table file descriptors. 2. How does the InnoDB storage engine handle deadlocks when they are detected? A. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back. B. The transaction isolation level determines which transaction is rolled back. C. One of the affected transactions will be rolled back, the other is allowed to proceed. D. Both the affected transactions will be rolled back, the other is allowed to proceed. E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back. 3. You want to upgrade the MySQL Server. In which two cases would you not use a binary backup? A. When you upgrade skipping a major version, for example, from 5.0 to 5.6 B. When you upgrade between major versions, for example from 5.5 to 5.6 C. When the Release Notes indicate either a data or index format between versions was changed D. When the Release Notes indicate that functionality between versions was changed E. When the Release Notes indicate that syntax between versions was changed 4. Which two statement are true about the mysql_upgrade command? A. The mysql_upgrade command is a utility that patches the mysqld binary from its base version to a new version. B. The mysql_upgrade command is run to check and attempt to fix tables for certain incompatibilities with the current version of MySQL. C. The mysql_upgrade command executes on a stopped MySQL server data directory to ensure that it is prepared for upgrade. D. The mysql_upgrade command also executes the mysqlcheck command in order to provide all of its functionality. 5. What are two functions of the maximum size of the relay log files if the value of max_binlog_size variable? (Choose two) A. It determines the maximum size of the relay log files if the value of max_relay_log_size is 0. B. It determines the collective maximum size for all binary log files created. C. It determines the size when the server will rotate the binary logs. D. It determines the maximum size of a transaction that can be written in a binary log in row based replication. E. It determines the maximum size of each binary log packet from the master to the slave. F. It determines the ceiling for a relay log and truncates to max_binlog_size.
咨询几道题目,请大神帮忙解答下 1. Which two statements are true about a table cache in MySQL? A. A global table cache is used for all open tables. B. A separate table cache is used for data in each open table. C. A table cache is used to cache frequently used table indexes. D. A table cache is used to cache the status of individual tables. E. A table cache is used to cache open table file descriptors. 2. How does the InnoDB storage engine handle deadlocks when they are detected? A. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back. B. The transaction isolation level determines which transaction is rolled back. C. One of the affected transactions will be rolled back, the other is allowed to proceed. D. Both the affected transactions will be rolled back, the other is allowed to proceed. E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back. 3. You want to upgrade the MySQL Server. In which two cases would you not use a binary backup? A. When you upgrade skipping a major version, for example, from 5.0 to 5.6 B. When you upgrade between major versions, for example from 5.5 to 5.6 C. When the Release Notes indicate either a data or index format between versions was changed D. When the Release Notes indicate that functionality between versions was changed E. When the Release Notes indicate that syntax between versions was changed 4. Which two statement are true about the mysql_upgrade command? A. The mysql_upgrade command is a utility that patches the mysqld binary from its base version to a new version. B. The mysql_upgrade command is run to check and attempt to fix tables for certain incompatibilities with the current version of MySQL. C. The mysql_upgrade command executes on a stopped MySQL server data directory to ensure that it is prepared for upgrade. D. The mysql_upgrade command also executes the mysqlcheck command in order to provide all of its functionality. 5. What are two functions of the maximum size of the relay log files if the value of max_binlog_size variable? (Choose two) A. It determines the maximum size of the relay log files if the value of max_relay_log_size is 0. B. It determines the collective maximum size for all binary log files created. C. It determines the size when the server will rotate the binary logs. D. It determines the maximum size of a transaction that can be written in a binary log in row based replication. E. It determines the maximum size of each binary log packet from the master to the slave. F. It determines the ceiling for a relay log and truncates to max_binlog_size.
1 下一页