908-test1

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

choose three.
Which three commands can report all the current connections running on the MySQL server?

choose three.

Which three are requirements for a secure MySQL Server environment?

Choose three.
Which three actions will secure a MySQL server from network-based attacks?

Choose two.
Which two statements are true about the data dictionary object cache?

choose two Examine Joe's account:
CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*' GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'
All existing connections for joe are killed.
Which two commands will stop joe establishing access to the MySQL instance?

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 three.
Which three sets of item information are visible in the mysql system database?

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 three.
Which three requirements must be enabled for group replication?

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.
Mary connects to a Linux MySQL Server from a client on a Windows machine. Examine this statement and output:
（含图）
Which two are true?

Choose two.

Examine these InnoDB Cluster parameter settings:

cluster.setInstanceOption('host1:3377', 'memberWeight', 40)

Cluster.setInstanceOption('host2:3377', 'memberWeight', 30)

Cluster.setInstanceOption('host3:3377', 'memberweight', 40)

cluster.setInstanceOption('host3:3377', 'exitstateAction', "ABORT_SERVER")

cluster.setOption ("expelTimeout",1)

Now examine the partial status:

（含图）

A permanent network failure isolates host3.

Which two statements are true?

Choose two.
You administer a three node, single primary InnoDB Cluster. Examine cluster.status() displayed here:
"statusText": "Cluster is ONLINE and can tolerate up to ONE failure." Which two statements are true?

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

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

Choose two.
You have semi-synchronous replication configured and working with one slave. rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true?

choose two.
Which two statements are true about raw binary backups?

Choose two.
You are investigating performance problems in a MySQL database; all data fits in memory. You determine that SELECT queries to one table is the main cause for poor response times. Which two have the biggest potential for eliminating the problem?

Choose two.
Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.
Which two sets of actions when completed will accomplish this?

Choose three.
Which three methods display the complete table definition of an InnoDB table?

1 5 6 7 8 9 10

更多题库