OCP-MYSQL8.0_在线真题试卷与模拟练习_OCP-MYSQL8.0_考试宝

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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

Examine this parameter setting: Audit_log=FORCE_LOG_OERMAENT What effect does this have on auditing?

You recently upgraded your MYSQL installation to MYSQL8.0 Examine this client error:

Error 2059 (HY000):authentication plugin ‘caching_sha2_password’ cannot be

Loaded: /usr/local/mysql/libplugin/caching_sha2_password.so: cannot open shared object file: No such or directory

Which option will allow this client to connect to MYSQL Server?

Examine this snippet from the binary log file named binlog.000036: （含图） Which command will complete the recovery?

Examine this command and output: （含图） Which statement is true?

You wish to protect your MySQL database against SQL injection attacks.

Which method would fail to do this?

You are using an existing server with a new configuration. MySQL Server fails to start. Examine this snapshot of （含图） Which action would allow the server to start?

Four nodes are configured to use circular replication. Examine these configuration parameters for each node: Slave_parallel_type=DATABASE Slave_parallel_workers=4 Slave_preserve_commit_order=0 Which statement is true?

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

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your Installation. （含图） What statement is true about the start attempt?

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?

Which statement is true about InnoDB persistent index statistics?

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

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database. Company policy is to create a backup every day. The main tables being updated are prefixed with transactions-. These tables are archived into tables that are prefixed with archives- each month. Mysqlbackup --optimistic -busy-tables=”^finance\.transactions.∗” backup Which optimization process best describes what happens with the redo logs?

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

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?

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

What does the slave I/O thread do?

The languages table uses MyISAM and the countries table uses the InnoDB storage engine. Both tables are empty. Examine these statements: BEGIN; INSERT INTO languages(lang) VALUES (“Italian”); INSERT INTO countries(country) VALUES(“Italy”); ROLLBACK; What is the content of both tables after executing these statements?

Examine these two reports taken 100 seconds apart: GLOBAL STATUS 1: Com_create_table=500005 Com_drop_table=500003 Com_flush=23 Create_tmp_disk_tables=400000 Create_tmp_tables=1200000 Max_used_connections=92 Open_files=5000 Opened_files=5000 Open_table_definitions=3000 Open_tables=1024 Opened_table_definitions=2369 Opened _tables=3500000 Threads_connected=62 Threads_running=58 Uptime=100000 GLOBAL STATUS 2: Com_create_table=500505 Com_drop_table=500498 Com_flush=31 Create_tmp_disk_tables=400400 Create_tmp_tables=1201200 Max_used_connections=92 Open_files=5000 Opened_files=7505 Open_table_definitions=3000 Open_tables=1024 Opened_table_definitions=2873 Opened _tables=3503500 Threads_connected=67 Threads_running=64 Uptime=100000 Your MySQL system normally supports 50-75 concurrent connections. Which configuration change will improve performance?