MySQL8.0-OCP

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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

（含图）

Choose the best answer.

A colleague complains about slow response time on your website. Examine this query and output:

（含图）

What is the most likely cause for the high number of lock waits?

（含图）

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?

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?

Examine this SQL statement:

UPDATE world.city

SET Population = Population * 1.1

WHERE CountryCode IN (SELECT Code FROM world.country

WHERE Continent = ' Asia ' )

Which set of privileges will allow Tom to execute this SQL statement?

You reconfigure and start a slave that was not replicating for several days. The configuration file and CHANGE MASTER command are correct.

Examine the GTID information from both master and slave:

（含图）

Which statement is true?

Which step or set of steps can be used to rotate the error log?

What does the binlog dump thread do?

Choose the best answer. You execute this command:
Shell> mysqlpump --exclude-databases=% --users Which statement is true?

Choose the best answer.
Which feature is provided by multi-source replication?

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

You issue this command:
SHOW SLAVE STATUS
In the output, there is a value for seconds_behind_master. How is this time calculated?

Choose the best answer.
Consider this shell output and executed commands:
[root@oel7~] # ps aux | grep mysqld
Mysql 2076 3.5 24.6 1386852 372572 2 Ssl 12:01 0:01 /usr/sbin/mysqld
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?

Choose the best answer.
You must replay the binary logs on your MySQL server. Which command do you use?

Choose the best answer.
You are using an existing server with a new configuration. MySQL Server fails to start. Examine this snapshot of the error log:
190925 12:49:05 InnoDB: Initializing buffer pool, size = 3.0G 190925 12:49:05 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 26214400 bytes!
190925 12:49:05 [ERROR] Plugin 'InnoDB' init function returned error .
190925 12:49:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 190925 12:49:05 [ERROR] Aborting
190925 12:49:05 [Note] /usr/sbin/mysqld: Shutdown complete Which action would allow the server to start?

Choose the best answer

Users report errors when trying to connect from 192.0.2.5 and is connecting using the mysql_native password authentication plugin.

Examine these commands and output:

（含图）

Which statement identifies the cause of the errors?

Choose the best answer

You have configured MySQL Enterprise Transparent Data Encryption (TDE).

What command would you use to encrypt a table?

Choose the best answer.
There has been an accidental deletion of data in one of your MySQL databases.
You determine that all entries in the binary log file after position 1797 must be replayed. Examine this partial command:
Mysqlbinlog binlog.000008 --start-position=1798 Which operation will complete the command?

Choose the best answer.
Which utility would you use to view the queries in the slow query log sorted by average query time?

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

1 2 3 4 5 6 9

更多题库