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

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Examine this command, which executes successfully:mysqlbackup --user=dba --password --port=3306 --with-timestamp --backup-dir=/export/backups backup-andapply-log Which statement is true?

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: Master: Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-321, Bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-50, Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237 Gtids_purged: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-100, Bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-10, Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237 Slave: Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-160, Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237 Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-70, Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237 Which statement is true?

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?

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

Mysql>SHOW GLOBAL VARIABLES

WHERE Varisble_name=’tmpdir ‘

OR Variable_name =’ tmp_table_size;

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

| Variable_name |Value |

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

|tmp_tabe_size | 16777216|

|tmpdir | /tmp |

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

Shell>cd/var/lib/mysql

Shell>ls -1|grep temp

Drwxr-x---.2 mysql mysql 4096 Dec 11 14:05 #innodb_temp

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

Examine the command, which execute successfully:

Shell> mysqld --initialize-insecure

Which statement is true?

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

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?

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?

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?

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

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?

Examine the full path name of the backup image from MySQL Enterprise Backup with the --compress option: /backup/full/mybackup/myimage.img Mysqlbackup.cnf contains this data: [mysqlbackup] Backup-dir=/backup/full/myrestore Backup-image=/backup/full/mybackup/myimage.img uncompress You must perform a database restore to a new machine. Which command can provision the new database in datadir as /data/MEB?

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?

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

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?

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

Examine these statements and output: Mysql>GRANT PROXY ON accounting@locahost TO ‘’@’%’; Mysql>SELECT USER(),CURRENT_USER(),@@PROXY_USER; +-------------------+---------------------+----------------+ |USER() |CURRENT_USER() |@@proxy_user| +-------------------+---------------------+----------------+ |jsmith@loaclhost | accounting@localhost |’’@’% | +-------------------+---------------------+----------------+ Which statement is true?

Examine this command, which executes successfully: $mysqlbackup --user=dba --password --port=3306 --with-timestamp --only-know-file-types --backup-dir=/exprot/backups backup Which statement is true?

Examine these entries from the general query log: Time Id Command Argument 2019-12-17T00:36:23.389450z 24 Connect root@localhost on mydb using SSL/TLS 2019-12-17T00:36:23.389450z 24 Query select @@version_comment limit 1 2019-12-17T00:36:23.929519z 25 Connect root@localhost on mydb using SSL/TLS 2019-12-17T00:36:23.929846z 25 Query select @@version_comment limit 1 2019-12-17T00:36:27.633082z 24 Query START TRANSACTION 2019-12-17T00:36:30.321657z 24 Query UPDATE t1 SET val =1 WHERE ID=130 2019-12-17T00:36:32.417433z 25 Query START TRANSACTION 2019-12-17T00:36:33.617642z 25 Query UPDATE t2 SET val =5 WHERE ID=3805 2019-12-17T00:36:36.045498z 25 Query UPDATE t1 SET val =10 WHERE ID=130 2019-12-17T00:36:33.617642z 25 Query UPDATE t2 SET val =5 WHERE ID=3805 2019-12-17T00:36:38.513674z 24 Query UPDATE t2 SET val =42 WHERE ID=3805 All UPDATE statements reference existing rows. Which describes the outcome of the sequence of statements?

1 2 3 4 5 6 11