908-test1

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Choose the best answer.
You have configured GTID-based asynchronous replication with one master and one slave. A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:
（含图）
You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?

Choose the best answer.
You have configured a working MySQL InnoDB Cluster in single-primary mode. What happens when the primary instance goes down due to a network problem?

choose the best answer.
Which characters are most commonly used in a SQL injection attack?

choose the best answer.

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?

Choose the best answer. Examine these commands and results:
SHOW GRANTS FOR jane; GRANT USAGE ON *.* TO ‘’
（含图）
Jane must create a temporary table named TOTALSALES in the SALES database.
Which statement will provide Jane with the required privileges based on the principle of least privilege?

Choose the best answer.
Your MySQL Server is running locally on your Linux installation, and has SSL connections configured but not mandatory.
# mysql -u root -h localhost -p Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9
Server version: 8.0.18-commercial MySQL Enterprise Server - Commercial mysql> STATUS;
Connection id: 9 Current database:
Current user: root@localhost SSL: Not in use
Current pager: stdout Using outfile:' ' Using delimiter: ;
Server version: 8.0. 18-commercial MySQL Enterprise Server - Commercial Protocol version: 10
Connection: Localhost via UNIX socket server characterset: utf8mb4
Db characterset: utf8mb4 Client characterset: utf8mb4 Conn. characterset: utf8mb4
UNIX socket: /var/lib/mysql/mysql.sock Uptime: 2 min 54 sec
Threads: 2 Questions: 10 slow queries: 0 opens: 132 Flush tables: 3 open tables: 52 Queries per
Second avg: 0.057
Mysql> SHOW GLOBAL VARIABLES WHERE Variable_name LIKE 'ssl%' AND Value !='';
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| ssl_ca | ca.pem |
| ssl_cert | server-cert.pem |
| ssl_fips_mode | OFF |
| ssl_key | server-key.pem |
+---------------+-----------------+
What is the reason for SSL not being used?

choose the best answer.

Your my.cnf file contains these settings:

[mysqld]

log_output=FILE

slow_query_log

long_query_time=2.01

Log_queries_not_using_indexes

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?

choose the best answer.
Which condition is true about the use of the hash join algorithm?

choose the best answer.
You encountered an insufficient privilege error in the middle of a long transaction. The database administrator is informed and immediately grants the required privilege: GRANT UPDATE ON world.city TO 'user1' ;
How can you proceed with your transaction with the least interruption?

Choose the best answer.
You use Row Based Replication and need to see "pseudo-SQL" statements for the replication event that is located in the log_file position NNNNN file.
Which command should you use?

Choose the best answer.
Examine the command, which executes successfully:
Shell> mysqld --initialize Which statement is true?

chooose the best answer.

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?

choose the best answer.
Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'. Which command will do this?

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

choose the best answer.
What is the correct syntax for using transparent data encryption with an existing InnoDB table?

choose the best answer.
You wish to protect your MySQL database against SQL injection attacks. Which method would fail to do this?

choose the best answer.
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname :port --directory=directory_path Which activity is performed?

choose the best answer.
Examine this command:
Shell> mysqldump --no-create-info --all-databases --result-file=dump.sql Which statement is true?

choose the best answer.
How can mysql_multi be configured to allow MySQL instances to use the same port number?

Choose two.
You have an installation of MySQL 8 on Oracle Linux. Consider the outputs:
（含图）
Which statement is true about disk temporary tables for this installation?

1 2 3 4 5 6 10

更多题库