908 ALL_在线真题试卷与模拟练习_908 ALL

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Examine this command, which executes successfully:

（含图）

Which statement is true?

You reconfigure and start a slave that was not replicating for several days. The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:（含图）Which statement is true?

You want to log only the changes made to the database objects and data on the MySQL system. Which log will do this by default?

You have an installation of MySQL 8 on Oracle Linux. Consider the outputs:

（含图）

Which statement is true about disk temporary tables for this installation?

Examine the command, which executes successfully:

（含图）

Which statement is true?

Examine this command:

Mysqldump --no-create-info --all-databases --result-file=dump.sql

Which statement is true?

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

（含图）

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

A command is executed:

（含图）

What is the result?

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?

There has been an accidental deletion of data in one of your MySQL databases.

You determine that all entries in the binary log file after position 1797 must be replayed. Examine this partial command:

（含图）

Which operation will complete the command?

You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of rows from 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?

You are having performance issues with MySQL instances monitored by MySQL Enterprise Monitor. Using Query Analyzer, where do you begin to look for problem queries?

Examine the full path name of the backup image from MySQL Enterprise Backup with the --compress option: /backup/full/mybackup/myimage.img Mysqlbackup.cnf contains:（含图） You must perform a database restore to a new machine. The data directory is /data/MEB. Which command can provision the new database in datadir as /data/MEB?

You encountered an insufficient privilege error in the middle of a long transaction.

The database administrator immediately grants the required privilege:

How can you proceed with your transaction with the least interruption?

You want to check the values of the sort_buffer_size session variables of all existing connections. Which performance_schema table can you query?

Your my.cnf file contains these settings:

（含图）

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.

Which contains all the settings that you need to add to or modify the slow log configuration?

What is the correct syntax to enable Transparent Data Encryption (TDE) on an existing InnoDB table?

（含图）

Which statement is true?

Examine this command, which executes successfully:

【$ mysqlbackup --user=dba --password --port=3306 --with-timestamp --only-known-file-types --backup-dir=/export/backups backup】

Which statement is true?

Examine these entries from the general query log:

Time Id Command Argument

2019-12-17T00:36:23.389450z 24 Connect root@localhost on mydb using SSL/TLS

2019-12-17T00:36:23.389450z 24 Query select @@version_comment limit 1

2019-12-17T00:36:23.929519z 25 Connect root@localhost on mydb using SSL/TLS

2019-12-17T00:36:23.929846z 25 Query select @@version_comment limit 1

2019-12-17T00:36:27.633082z 24 Query START TRANSACTION

2019-12-17T00:36:30.321657z 24 Query UPDATE t1 SET val=1 WHERE ID=130

2019-12-17T00:36:32.417433z 25 Query START TRANSACTION

2019-12-17T00:36:33.617642z 25 Query UPDATE t2 SET val=5 WHERE ID=3805

2019-12-17T00:36:36.045498z 25 Query UPDATE t1 SET val=10 WHERE ID=130

2019-12-17T00:36:38.513674z 24 Query UPDATE t2 SET val=42 WHERE ID=3805

All UPDATE statements reference existing rows.

Which describes the outcome of the sequence of statements?

Examine this output:

（含图）

.4 rows in set (0.00 sec)

Which change should optimize the number of buffer pool instances for this workload?

1 2 3 4 5 6 11