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

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Choose two.Your MySQL server was upgraded from an earlier major version.The sales database contains three tables, one of which is the transactions table, which has 4 million rows.You are running low on disk space on the datadir partition and begin to investigate Examine these commands and output（见图片）Which two statements are true?

（含图）

['title', 'EXPLAIN'] （含图）

Choose four.A newly deployed replication master database has a 10/90 read to write ratio. The complete dataset is currently 28G but will never fluctuate beyond +-10%.The database storage system consists of two locally attached PCI- E Enterprise grade disks (mounted as /data1 and /data2.The server is dedicated to this MySQL Instance System memory capacity is 64G.The my.cnf file contents are displayed here mysqlddatadir=/data1/ innodb_buffer_pool_size=28G Innodb_log_file_size=150MWhich four changes provide the most performance improvement,Without sacrificing data integrity?

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

Choose four.You must store connection parameters for connecting a Linux-based MySQL client to a remote Windows-based MySQL server listening on port 3309.Which four methods can be used to configure user, host, and database parameters?

Choose two.Examine this command and output、（见下图）Which two options will improve the security of the MySQL instance?

（含图）

Choose two.Which two statements are true about general tablespaces?

Choose three、Examine this command, which executes successfully cluster.addInstance( '

<user>@<host>、<port>' , recoveryMethod' clone '. Which three statements are true?

Choose three Which three sets of item information are visible in the mysql system database?

Which two situations will cause the binary log to rotate?

Choose three Which three statements are true about MySQL replication?

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

32GAfter profiling the system,you highlight these MySQL status and global variables Com_rollback 85408355 Com_commit 1234342 Innodb_buffer_pool_pages_free 163840

MysqldBuffer_pool_size=20GInnodb_flush_log_at_trx_commit=2Disable-log-binThe 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?

Choose two.Examine this statement and output mysql> SHOW GRANTS FOR jsmith; Grants for jsmith@%GRANT USAGE ON ∗.∗ TO 'jsmith@'%'GRANT UPDATE (Name ON 'world country' TO 'jsmith'@'%'; 2 rows in set (0.00 sec Which two SQL statements can j smith execute?

Choose twoThere are five MySQL instances configured with a working group replication. Examine

The output of the group members、mysql> SELECT MEMBER_ID, MEMBER_STATE FROMperformance_schema replication_group_members;（见下图）Which two statements are true about network partitioning in the cluster?

（含图）

Choose two.Which two statements are true about InnoDB data-at-rest encryption?

Choose three Which three statements are true about MySQL Enterprise Firewall?

Choose two.Which two storage engines provide a view of the data consistent with the storage System at any moment?

Choose threeWhich three are requirements for a secure MySQL Server environment?

Choose two.Examine this list of MySQL data directory binary logs、binloG、000001binloG、000002.......binloG、000289binloG、000300binloG、000301binloG、indexNow Examine this command, which executes successfully、mysqldump --delete-master-logs --all Databases > /backup/db_backup.sqlWhich two are true?

You want to install and configure MySQL on Linux server with tarball binaries in the

/app/mysq1/directory, where the bin directory is found at 1 app/mysql/bin and the data directory

At /app/data.Which two parameters are required to configure the MySQL instance?

1 2 3 4 5 6 11

更多题库