mysql-908_在线真题试卷与模拟练习_mysql-908

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Choose the best answer. Examine this command, which executes successfully: $ mysqlbackup --user=dba --password --port=3306 --with-timestamp --only-known-file-types --backup-dir=/export/backups backup Which statement is true?

Choose the best answer. Your MySQL environment has asynchronous position based-replication with one master and one slave. The slave instance had a disk I/O problem, so it was stopped. You determined that the slave relay log files were corrupted and unusable, but no other files are damaged. You restart MySQL Server. How can replication be restored?

Choose the best answer host3: 3377 ssl JS > dba.rebootClusterFromCompleteOutage () Reconfiguring the default cluster from complete outage. . . The instance ' host1:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N] : y The instance ' host2:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N] : y Please use the most up to date instance: ' host1:3377'. (RuntimeError) Which statement is true?

Choose the best answer. You want to check the values of the sort_buffer_size session variables of all existing connections Which performance_schema table can you query?

Examine this partial output for InnoDB Cluster status: “topology”;{ “host1:3377”:{ ”address”;”host1:3377”, “mode”:”R/W”, [.......] “STATUS”:”ONLINE”, “version”;”8.0.18’ }, “host2:3377”:{ ”address”;”host2:3377”, “mode”:”R/O”, [.......] “STATUS”:”MISSING”, }, “host3:3377”:{ ”address”;”host3:3377”, “mode”:”R/O”, [.......] “STATUS”:”ONLINE”, “version”;”8.0.18’ } } Which statement explains the state of the instance deployed on host2?

Choose the best answer. Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

Choose the best answer. Which command enables rule-based MySQL Auditing capabilities?

Choose the best answer Examine this command, which executes successfully: mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back. Which statement is true about the copy-back process?

Choose the best answer. Examine this parameter setting: audit_log=FORCE_LOG_PERMANENT What effect does this have on auditing?

Choose the best answer. Which characters are most commonly used in a SQL injection attack?

干见下图（含图）

Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2' . Which command will do this?

Choose the best answer. MySQL is installed on a Linux server with this configuration: [mysqld] user=mysql datadir=/data/mysql Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

Choose the best answer. slave_preserve_commit_order=0 Which statement is true?

Choose the best answer. You are upgrading a MySQL instance to the latest 8.0 version. Examine this output:. （见下图） You plan to add this parameter to the configuration: innodb_directories= ' /innodb_extras ' Which statement is true?