mysql ocp_在线真题试卷与模拟练习_mysql ocp

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Choose the best answer.
Examine these statements and output:
Mysql> GRANT PROXY ON accounting@localhost TO ' '@'%' ;
Mysql> SELECT USER(), CURRENT_USER(), @@proxy_user;
（含图）
Which statement is true?

Choose the best answer.

Examine this statement, which executes successfully:

（含图）

You want to improve the performance of this query:

SELECT Name

FROM world.city

WHERE Population BETWEEN 1000000 AND 2000000;

Which change enables the query to succeed while accessing fewer rows?

Choose the best answer.

You are having performance issues with MySQL instances. Those servers are monitored with

MySQL Enterprise Monitor.

Using Query Analyzer, where do you begin to look for problem queries?

Choose the best answer.
You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?

Choose the best answer.
Examine these commands, which execute successfully on the ic1 host:
Mysqlsh> dba.createCluster( 'cluster1' , {memberWeight:35})
Mysqlsh> var mycluster = dba.getCluster ()
Mysqlsh> mycluster.addInstance ( 'ic@ic2' , {memberWeight:25})
Mysqlsh> mycluster.addInstance( 'ic@ic3' , {memberWeight:50})
Now examine this configuration setting, which is the same on all nodes:
Group_replication_consistency=BEFORE_ON_PRIMARY_FAILOVER
Which statement is true if primary node ic1 fails?

Choose the best answer.

You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.

Examine the 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.
You plan to upgrade your MySQL 5.7 instance to version 8.
You have installed the 8 build of MySQL Shell.
Examine this command executed from the operating system shell prompt:
Mysqlsh --uri root@localhost:3306 -- util check-for-server-upgrade
Which statement is true?

Choose the best answer.

Database test contains a table named city that has the InnoDB storage engine.

（含图）

What is the content of the test folder in the data directory?

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

Choose the best answer.
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
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
Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata.
Please use the most up to date instance: ' host1:3377'. (RuntimeError)
Which statement is true?

Choose the best answer.
Examine this partial report:
Mysql> SHOW FULL PROCESSLIST;
（含图）
Examine this query:
SELECT SUM(m.CURRENT_NUMBER_OF_BYTES_USED. AS TOTAL
FROM performance_schema.memory_summary_by_thread_by_event_name m
INNER JOIN performance_schema.threads t
ON m.THREAD_ID = t.THREAD_ID
WHERE t.PROCESSLIST_ID = 10;
What information does this query provide?

Choose the best answer.
You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?

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.
Which command enables rule-based MySQL Auditing capabilities?

Choose the best answer.
You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your data.
Examine your backup requirements:
·The MySQL system being backed up can never be unavailable or locked to the client applications.
·The recovery from the backup must work on any system.
·Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

Choose the best answer.
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?

Choose the best answer.
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:
# systemctl start mysqld
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
# systemctl status mysqld.service
Mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled).
Active: failed (Result: exit-codE. since Thu 2019-12-12 07:54:53 ACDT; 33s ago
Docs: man:mysqld(8)
Http://dev.mysql.com/a/doc/refman/en/using-systend.html
Process: 2732 Execstart=/usr/ sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/ FAILURE)
Process: 2705 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/ SUCCESS)
Main PID: 2732 (code=exited, status=1/FAILURE)
Status: "Server startup in progress "
Dec 12 07:54:49 oel7 systemd[1]: Starting MySQL Server...
Dec 12 07:54:53 oel7 systemd[1] : mysqld.service: main process exited, code=exited, status=1/FAILURE
Dec 12 07 :54:53 oel7 systemd[1] : Failed to start MySQL Server
Dec 12 07 :54:53 oel7 systemd[1] :Unit mysqld.service entered failed state.
Dec 12 07:54:53 oel7 systemd[1]: mysqld.service failed.
What statement is true about the start attempt?

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 these commands and output:
Mysql> SHOW FULL PROCESSLIST;
（含图）
Mysql> SELECT object_type, object_schema, object_name, lock_type, lock_status,
Owner_thread_id, owner_event_id
-> FROM performance_schema.metadata_locks WHERE object_schema !=
'performance_schema' ;
（含图）
Mysql> SELECT thread_id, processlist_id, processlist_user, parent_thread_id
-> FROM per formance_schema.threads WHERE processlist_user=' root';
（含图）
Which connection ID is holding the metadata lock?

Choose the best answer.
T is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN
SELECT * FROM t FOR UPDATE;
Which is true?

1 2 3 4 5

更多题库