新建题库04270428_在线真题试卷与模拟练习_新建题库04270428

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Choose the best answer.

Four nodes are configured to use circular replication. Examine these configuration parameters for each each node:slave_parallel_type=DATABASE ; slave_parallel_workers=4 slave_preserve_commit_order=0 Which statement is true?

Examine this partial output for InnoDB Cluster status:“topology”;“host1:3377”:”address”;”host1:3377”,“mode”:”R/W”,...................................................................................................................................................................................... “STATUS”:

”ONLINE”,“version”;”8.0.18’,“host1:3377”:”address”;”host2:3377”,“mode”:”R/O”,....

...“STATUS”:”MISSING”,,“host1:3377”:”address”;”host3:3377”,“mode”:”R/O”,..... “ST

ATUS”:”ONLINE”,“version”;”8.0.18’

Which statement explains the state of the instance deployed on host2?

Choose the best answer.Examine this command:shell> mysqldump --no-create-info --all-databases

--result-file=dump.sql Which statement is true?

MySQL programs look for option files in standard locations.Which method will show the option files and the order in which theyare read?

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?

What does the slave I/O thread do?

Choose the best answer.

Which statement is true about the my.ini file on a Windows platform while MySQL server is running?

Examine the full path name of the backup image from MySQL Enterprise Backup with the -- compress option:/backup/full/mybackup/myimage.imgmysqlbackup.cnf contains this data:mysqlbackupbackup-dir=/backup/full/myrestorebackup- image=/backup/full/mybackup/myimage.img uncompress

You must performa database restore to a new machine.which command can provision the new database in datadir as /data/MEB?

Choose the best answer.MySQL Enterprise Monitor Query Analyzer is configured to monitor an instance. Which statement istrue?

Choose the best answer

Users report errors when trying to connect from 192.0.2.5 and is connecting using the mysql_nativepassword authentication plugin.Examine these commands and output:（见下图）

（含图）

Which statement identifies the cause ofthe errors?

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

Choose the best answer.

Which feature is provided by multi-source replication?

Choose the best answer.

it is a non-empty InnoDB table.

Examine these statements, which are executed in onesession: BEGIN SELECT * FROM t FOR UPDATE;

Which is true?

Choose the best answer

You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in- place upgrade. Examinethe message sequence generated during the first start of MySQL 8.0.18:（见下图）

（含图）

Which step or set of steps will resolve the errors?

Choose the best answer.

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of rows of a large table named FACTORY.INVENTORY.Which command will reorganize the physical storage of table data and associatedindex data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?

Choose the best answer.

You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.Which value of --ssl-mode will do this?

Choose the best answer.

You want to dump all databases with names that start with \db\. Which command will achieve this?

You have an installation of MySQL 8 on Oracle Linux. Consider the outputs:（见下图）

（含图）

Which statement is true about disk temporary tables for this installation?

Choose the best answer.What is the correct syntax for using transparent data encryption with an existing InnoDB table?

1 2 3 4 5 6 12