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

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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

You have replication configured, which consists of one master and one slave on different hosts with an Asynchronous replication channel between them. Your goal is to decrease the amount of data that is transferred between these two hosts. It is confirmed that the slave instance does not need to have data from the example database. Which replication filter contributes to your goal?

Examine the command Shell# mysqldump --master-data=2 --all-databases > full_backup.sql You want to make incremental backups every hour after the full backup. Which loa file would be used for incremental backups?

MySQL Enterprise Monitor Query Analyzer is confiqured to monitor an instance. Which statement is true?

Which statement is true about cold backups?

Examine this statement, which executes successfully: Why does the file contain no visible statement events?

Which two authentication plugins require the plain text client plugin for authentication to work?

Which two actions will secure a MySQL server from network-based attacks?

You must export data from a set of tables in the world_x database. Examine this set of tables: Tables ( country, countryinfo, location) Which two option will export data into one or more files?

The data in this instance transient;no backup or replication will be required.It is currently under performing. The database size is static and including indexes is 19G Total system memory is 32G After profiling the system,you highlight these MySQL status and global variables: Com_rollback |85408355 | Com_commit |1234342 | Innodb_buffer_pool_pages_free |163840 | [mysqld] Buffer_pool_size=20G Innodb_flush_log_at_trx_commit=2 Disable-log-bin The OS metrics indicate that disk is a bottleneck. Other variables retain their default values. Which two changes will provide the most benefit to the instance?

All mysql server instances belonging to innodb cluster have SSL configured and enabled. You must configure Innodb cluster to use SSL for group communication. Which two statements are ture?

Which two are true about differences between logical and physical upgrades of MySQL databases?

An existing asynchronous replication setup is running MySQL 8.

Which two steps are a part of implementing GTID replication?

You are using mysqlcheck for server maintenance. Which two statements are true?

Examine this statement:

mysql> DROP ROLE r_role1, r_role2;

Which two are true?

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin Login credentials to connect to a MySQL server running Microsoft Windows on remote host 192.0.2.1:3306 to Connect to the world database. Which four options need to be specified to complete this task with a single command?

Examine this command and output:

SELECT * FROM data_locks LIMIT 1\G

∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗

ENGONE: INNODB

ENDINE_LOCJK_I: 1200:146

ENGINE_TRANSACTION_ID: 1200

THREAD_ID:45

ECENT_ID:11

OBJECT_SCHEMA: mydb

OBJECT_NAME: mytable1

PARTITION_NAME: NULL

SUSPARTITION_NAME: NULL

INDEX_NAME: NULL

OBJECT_INSTANCE_BEGIN:118793337250203

LOCK_TYOE: RECORD

LOCK_MODE: X

LOCK_STATUS: GRANTED

LOCK_DATA: 1922,192

Which two statements are true?

A clean shutdown was performed with innodb_fast_shutdown=0. While you were manipulating files, all files were accidentally deleted from the top-level data directory. Which two Files must be restored from backup to allow the DB to restart cleanly?

1 3 4 5 6 7 11