8.0 ocp_在线真题试卷与模拟练习_8.0 ocp_考试宝

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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?

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=150M

Which four changes provide the most Performance improvement, without sacrificing data integrity?

Examine this command and output:

（含图）

Which two options will improve the security of the MySQL instance?

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

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?

Examine this statement, which executes successfully：CREATE TABLE employees (emp_no int unsigned NOT NULL, birth_date date NOT NULL, first_name varchar(14) NOT NULL, last_name varchar(16) NOT NULL, hire_date date NOT NULL, PRIMARY KEY (emp_no))ENGINE=InnoDB;Now examine this query：SELECT emp_no, first_name, last_name, birth_date FROM employeesWHERE MONTH (birth_datE. = 4;You must add an index that can reduce the number of rows processed by the query. Which two statements can do this?

Which two queries are examples of successful SQL injection attacks?

Which two tools are available to monitor the global status of InnoDB locking?

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

Which three are types of information stored in the MySQL data dictionary?

Which four are types of information stored in the MySQL data dictionary?

Examine this SQL statement：mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION; Which two are true?

Which two statements are true about general tablespaces?

Which three methods are part of a 'scale up' approach to capacity planning?

A user wants to connect without entering his or her username and password on the Linux command prompt. Which three locations can be used to store the user's mysql credentials to satisfy this requirement?

Examine the modified output：mysql> SHOW SLAVE STATUS\\G ∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗1. row∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗ Slave_IO_Running：Yes Slave_SQL_Running：Yes Seconds_Behind_Master：1612 Seconds_Behind_Master value is steadily growing. What are two possible causes?

Which two are true about binary logs used in asynchronous replication?

You have appropriate privileges and are about to shut down a running MySQL server process on Oracle Linux 7.Which three are valid methods that will shut down the MySQL server?

Examine this MySQL Shell command：dba.rebootClusterFromCompleteOutage () Which two statements are true?

更多题库