MySQL OCP 908 题库_在线真题试卷与模拟练习_MySQL OCP 908 题库

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(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:

（含图）

Which statement is true?

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

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:

（含图）

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

Which are two of actions will secure a MySQL server from network-based attacks?(此题也可能是让选三个选项，选三个选项时答案见解析)

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?

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?

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?

（含图）

Which two are true?

You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number Of 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?

The data in this instance transient;

no backup or replication will be required.

It is currently under performing.

Examine these MySQL status and global variables:

（含图）

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?

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?

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?

1 2 3 4 5 6 12

更多题库