MySQL5.8-单选1_在线真题试卷与模拟练习_MySQL5.8-单选1

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Your MySQL environment has asynchronous position based-replication with one master and one slave。 The slave instance had a disk I/O problem, so it was stopped You determined that the slave relay log files were corrupted and unusable, but no other files are damaged You restart MySQL Server How can replication be restored ?

Examine the command，which execute successfully: shell\> mysqld --initialize-insecure Which statement is true?

Which statement is true about MySQL Enterprise Transparent Data Encryption

The mysqld instance（ has the connection control plugin enabled with these settings:

Connection_control_min_connection_delay=1000

Connection_control_max_connection_delay=2000

The minimum and maximum delays need to be increased to 3000 and 5000, respectively。

A command is executed: Mysql\> SET GLOBAL connection_control_min_connection_delay=3000;

What is the result?

You wish to protect your MySQL database against SQL injection attacks（SQL注入攻击）。 Which method would fail to do this

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database

Company policy is to create a backup every day

The main tables being updated are prefixed with transactions

These tables are archived into tables that are prefixed with archives- each month

Mysqlbackup --optimistic -busy-tables=”^finance\。transactions。*” backup

Which optimization process best describes what happens with the redo logs?

Database test contains a table named city that has the InnoDB storage engine

CREATE TABLE ‘city' ( 'ID' int NOT NULL AUTO_ INCREMENT ,

‘Name’ char(35) NOT NULL DEFAULT '',

‘Countrycodechar’(3) NOT NULI DEFAULT '',

‘District' char (20) NOT NULI DEFAULT ' ',

‘Population' int NOT NULI DEFAULT '0',

PRIMARY KEY('ID') ,

KEY 'CountryCode' ( ' Countrycode’ )

) ENGINE= InnoDB

TABLESPACE=innodb_ file_ per_ table;

What is the content of the test folder in the data directory?

Examine this set of messages and responses:

host3:3377 ssl JS \> dba。 rebootClusterFromCompleteOutage ()

Reconfiguring the default cluster from completeoutage。

The instance'host1 :3377'' was part of the cluster configuration

Would you like to rejoin it to the cluster? [y/N] : y

The instance 'host2 :3377'was part of the cluster configuration

Would you like to rejoin it to the cluster? [y/N] : y

Dba。rebootClusterFromCompleteOutage :

The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster' s metadata。

Please use the most up to date instance: 'host1 :3377' (RuntimeError )

Which statement is true?

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases。Which command will back up the databases in parallel?

MySQL Enterprise Monitor Query Analyzer is confiqured to monitor an instance Which statement is true?

What is the correct syntax for using transparent data encryption with an existing InnoDB table

You wish to store the username and password for a client connection to MySQL server in a file on a local file system Which is the best way to encrypt the file?

A developer accidentally dropped the InnoDB table Customers from the Company database。

There is a datadir copy from two days ago in the dbbackup directory

Which set of steps would restore only the missing table?

You must replay the binary logs on your MysQL server

Which command do you use?

You want to dump all databases with names that start with db

Which command will achieve this?

Examine these two reports taken 100 seconds apart:

GLOBAL STATUS 1:

Com_create_table=500005

Com_drop_table=500003

Com_flush=23

Create_tmp_disk_tables=400000

Create_tmp_tables=1200000

Max_used_connections=92

Open_files=5000

Opened_files=5000

Open_table_definitions=3000

Open_tables=1024

Opened_table_definitions=2369

Opened _tables=3500000

Threads_connected=62

Threads_running=58

Uptime=100000

GLOBAL STATUS 2:

Com_create_table=500505

Com_drop_table=500498

Com_flush=31

Create_tmp_disk_tables=400400

Create_tmp_tables=1201200

Max_used_connections=92

Open_files=5000

Opened_files=7505

Open_table_definitions=3000

Open_tables=1024

Opened_table_definitions=2873

Opened _tables=3503500

Threads_connected=67

Threads_running=64

Uptime=100000

Your MySQL system normally supports 50-75 concurrent connections

Which configuration change will improve performance?

You want to check the values of the sort_buffer_size session variables of all existing connections。

Which performance_schema table can you query

Examine this statement, which executes successfully:

Why does the file contain no visible statement events?

Which statement is true about cold backups

Which command enables rule -based MySQL Auditing capabilities

1 2 3