A simple master-to-slave replication i...

单项选择题X 纠错

A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:
Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query.
Default database: 'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') ' Skip_Counter: 0 Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1
You execute a "SHOW CREATE TABLE mytable" on the slave: CREATE TABLE 'mytable' ( 'ID' int(11) NOT NULL
DEFAULT '0', 'name' char(10) DEFAULT NULL, PRIMARY KEY ('ID') )
The table mytable on the slave contains the following:

You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used（）

A.SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
B.SET GLOBAL enforce_gtid_consistency=ON
C.SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9"
D.SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
E.SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

参考答案：

进入题库练习

查答案就用赞题库小程序还有拍照搜题语音搜题快来试试吧

无需下载立即使用

你可能喜欢

多项选择题

A general purpose MySQL instance is configured with the following options:
—log-slow-queries
—long-query-time=,0001
—log-slow-admin-queries
—general-log
—log-bin
—binlog-format=STATEMENT
—innodb-flush-log-at-trx-commit=1
Which three statements are true（）。

A.The General Query Log records more data than the Binary Log
B.The binary Log records more data than the General Query Log
C.The Slow Query Log records more data than the General Query Log
D.The General Query Log records more data than the Slow Query Log
E.The Slow Query Log records more data than the Binary Log
F.The Binary Log records more data than the Slow Query Log

点击查看答案进入题库练习

多项选择题

Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?（）

A.Both technologies guarantee an identical copy of data on the secondary node
B.Only MySQL can maintain a time-delayed copy of data on the secondary node
C.Both technologies use the TCP/IP stack as their primary transmission medium
D.DRBD uses shared-disk technology

点击查看答案进入题库练习

单项选择题

Consider the MySQL Enterprise Audit plugin.
On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error.
In the audit log file, you notice the final entry:
…

What action should you take to fix the error and allow the service to start?（）

A.Re-install the audit plugin
B.Execute the command FLUSH LOGS
C.Execute the command SET GLOBAL audit_log_fiush= ON
D.Move or rename the existing audit.log file

点击查看答案进入题库练习

单项选择题

What is true regarding InnoDB locking?（）

A.InnoDB uses row and table-level locks, but row locks are not escalates
B.InnoDB locks only those rows that are updated
C.InnoDB only uses row locks, not page or table-level locks
D.InnoDB row locks may be escalated to page or table-level locks
E.InnoDB uses row-level or table-level locks depending on the number of rows affected

点击查看答案进入题库练习

单项选择题

Your developers have created table to store some of their program's data.
After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.
An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…'
What should you do to improve the overall performance?（）

A.Convert the column to TEXT and add a fulltext index to the table
B.Create multiple prefix indexes of differing lengths
C.Convert their column to BINARY
D.Redesign the table so that the most commonly searched for string patterns are in their own columns

点击查看答案进入题库练习

单项选择题

Which statement is true about the log-output variable?（）

A.It is a static variable and can be set only at MySQL server startup
B.It enables and starts the General Query Log
C.It sets the target location for the binary logs generated by the MySQL sever
D.It specifies output destinations for the slow and General Query logs

点击查看答案进入题库练习

单项选择题

While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.
Which method will reduce the number of file handles in use?（）

A.Activating the MySQL Enterprise thread pool plugin
B.Relocating your data and log files to separate storage devices
C.Disconnecting idle localhost client sessions
D.Implementing storage engine data compression options

点击查看答案进入题库练习

多项选择题

In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（）
Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1;
mysql＞ TRUNCATE t1;

A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B.Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
C.$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql
D.Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
E.$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

点击查看答案进入题库练习

单项选择题

You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）

A.Include-master-info
B.Master-binlog
C.Include-log-file
D.Master-data

点击查看答案进入题库练习

多项选择题

You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.
Which two variables would likely fix this issue?（）

A.Table_open_cache
B.Table_open_cache_instancs
C.Table_definition_cache
D.Tmp_table_size
E.Max_heap_table_size
F.Max_tmp_tables

点击查看答案进入题库练习

赞题库

赞题库-搜题找答案

（已有500万+用户使用）

历年真题
章节练习
每日一练
高频考题
错题收藏
在线模考
提分密卷
模拟试题

无需下载立即使用

手机版电脑版