MySQL8.0-OCP

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Choose the best answer.

You have configured GTID-based asynchronous replication with one master and one slave. A user accidentally updated some data on the slave.

To fix this, you stopped replication and successfully reverted the accidental changes.

Examine the current GTID information:

（含图）

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.

Which set of actions would allow the slave to continue replicating without erroneous transactions?

Choose the best answer.
You have configured a working MySQL InnoDB Cluster in single-primary mode. What happens when the primary instance goes down due to a network problem?

Which characters are most commonly used in a SQL injection attack?

The mysqld instance has the connection control plugin enabled with these settings: connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000
The minimum and maximum delays need to be increased to 3000 and 5000, respectively. A command is executed:
Mysql> SET GLOBAL connection_control_min_connection_delay=3000; What is the result?

Choose the best answer. Examine these commands and results:

SHOW GRANTS FOR jane; GRANT USAGE ON *.* TO ‘’

（含图）

Jane must create a temporary table named TOTALSALES in the SALES database.

Which statement will provide Jane with the required privileges based on the principle of least privilege?

Choose the best answer.

Your MySQL Server is running locally on your Linux installation, and has SSL connections configured but not mandatory.

# mysql -u root -h localhost -p Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9

Server version: 8.0.18-commercial MySQL Enterprise Server - Commercial mysql> STATUS;

Connection id: 9 Current database:

Current user: root@localhost SSL: Not in use

Current pager: stdout Using outfile:' ' Using delimiter: ;

Server version: 8.0. 18-commercial MySQL Enterprise Server - Commercial Protocol version: 10

Connection: Localhost via UNIX socket server characterset: utf8mb4

Db characterset: utf8mb4 Client characterset: utf8mb4 Conn. characterset: utf8mb4

UNIX socket: /var/lib/mysql/mysql.sock Uptime: 2 min 54 sec

Threads: 2 Questions: 10 slow queries: 0 opens: 132 Flush tables: 3 open tables: 52 Queries per

Second avg: 0.057

Mysql> SHOW GLOBAL VARIABLES WHERE Variable_name LIKE 'ssl%' AND Value !='';

+ ----------------+---------------- +

| Variable_name | Value|

+---------------- +---------------- +

| ssl_ca | ca.pem |

| ssl_cert | server-cert.pem |

| ssl_fips_mode | OFF |

| ssl_key | server-key.pem |

+ ---------------+----------------- +

What is the reason for SSL not being used?

Your my.cnf file contains these settings:
[mysqld] log_output=FILE slow_query_log long_query_time=2.01
Log_queries_not_using_indexes
You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

解析：Which condition is true about the use of the hash join algorithm?

You encountered an insufficient privilege error in the middle of a long transaction. The database administrator is informed and immediately grants the required privilege: GRANT UPDATE ON world.city TO 'user1' ;
How can you proceed with your transaction with the least interruption?

Choose the best answer.

You use Row Based Replication and need to see "pseudo-SQL" statements for the replication event that is located in the log_file position NNNNN file.

Which command should you use?

Choose the best answer.
Examine the command, which executes successfully:
Shell> mysqld --initialize Which statement is true?

A developer accidentally dropped the InnoDB table Customers from the Company database. There is a datadir copy from two days ago in the dbbackup directory.
Which set of steps would restore only the missing table?

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

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 is the correct syntax for using transparent data encryption with an existing InnoDB table?

You wish to protect your MySQL database against SQL injection attacks. Which method would fail to do this?

Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname :port --directory=directory_path Which activity is performed?

Examine this command:
Shell> mysqldump --no-create-info --all-databases --result-file=dump.sql Which statement is true?

How can mysql_multi be configured to allow MySQL instances to use the same port number?

Choose two.

You have an installation of MySQL 8 on Oracle Linux. Consider the outputs:

（含图）

Which statement is true about disk temporary tables for this installation?（pdf答案缺少）

1 2 3 4 5 6 9

更多题库