908-test1

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

choose the best answer
Examine the command, which execute successfully:
Shell> mysqld --initialize-insecure
Which statement is true?

choose the best answer
The languages table uses MyISAM and the countries table uses the InnoDB storage engine. Both tables are empty. Examine these statements:
BEGIN;
INSERT INTO languages(lang)VALUE("Italien"),
INSERT INTO countries(country)VALUE("Italy");
ROLLBACK;
What is the content of both tables after executing these statements?

choose the best answer.
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?

choose the best answer
You want to dump all databases with names that start with "db". Which command will achieve this?

Choose two.
Which two actions can obtain information about deadlocks?

Choose two.
User `fwuser`@`localhost` is registered with the MySQL Enterprise Firewall and has been granted privileges for the SAKILA database.
Examine these commands that you executed and the results:
Mysql> SELECT MODE FROM INFORMATION_SCHEMA.MYSQL_FIREWALL_USERS
WHERE USERHOST = 'fwuser@localhost' ;
（含图）
Mysql> SELECT RULE FROM INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST
WHERE USERHOST = 'fwuser@localhost';
（含图）
You then execute this command:
Mysql> CALL mysql.sp_set_firewall_mode('fwuser@localhost' , 'RESET') ; Which two are true?

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?

choose two.
Identify two ways to significantly improve data security.

choose two.
Which two statements are true about MySQL Enterprise Backup?

choose two.
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure?

choose four.
Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server?

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

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

Choose two.
User account baduser@hostname on your MySQL instance has been compromised. Which two commands stop any new connections using the compromised account?

choose the two.
You plan to install MySQL Server by using the RPM download. Which two statements are true?

There are five MySQL instances configured with a working group replication. Examine the output of the group members:

Mysql> SELECT MEMBER_ID, MEMBER_STATE FROM

Performance_schema.replication_group_members;

（含图）

Which two statements are true about network partitioning in the cluster?

choose three.
You must run multiple instances of MySQL Server on a single host. Which three methods are supported?

choose three.
Which three settings control global buffers shared by all threads on a MySQL server?

choose two.
Which two statements are true about the mysql_config_editor program?

choose three.
Your MySQL server is running on the Microsoft Windows platform. Which three local connection protocols are available to you?

更多题库