MYSQL8.0-2024.12_在线真题试卷与模拟练习_MYSQL8.0-2024.12

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(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? （含图）图片地址: https://oss-emcsprod-public.modb.pro/image/exam/question_1640079592439.jpg

Choose two.['title', 'EXPLAIN']

Examine this query and output:

Mysql> EXPLAIN ANALYZE

SELECR city.CountryCode,contry,Name AS Country_Nae,

FROM world.city

INNER JOIN world.country ON country.Code =city.CountryCode

WHERE country.Continent=’Asia’

AND city.Population >100000

ORDER BY city,Population DESC\G

***********************************1.row*****************************

（含图）

图片地址: https://oss-emcsprod-public.modb.pro/image/exam/question_1640081699252.jpg

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:mysqld datadir=/data1/ innodb_buffer_pool_size=28G innodb_log_file_size=150M Which 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 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 employees WHERE 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?

Choose two.Which two queries are examples of successful SQL injection attacks?

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

Choose two.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? (Choose four.)

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

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

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

Choose three.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?

choose two.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?

Choose two.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?

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

Choose two.Examine this command and output:（见下图）Which two options will improve the security of the MySQL instance? （含图）图片地址: https://oss-emcsprod-public.modb.pro/image/exam/question_1640745666121.jpg

1 2 3 4 5 6 12

更多题库