单选题 
A、
The Event Scheduler is not enabled on the slave host
B、
The slave is waiting for an event to come into the relay log.
C、
The slave thread is waiting for another event to finish in another slave thread
D、
The binary log on the master is not being updated.
单选题 Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?
B、
SAN (Fibre Channel) Lun
C、
NFS (Networked File System) mount
D、
battery-backed locally-attached RAID 5 array
单选题 
A、
if it is possible for you to include any indexes in your query
B、
whether there are any indexes on the tables that you are querying
C、
if there are any indexes that may be used to solve this query
D、
whether there are any indexes in your query
单选题 As the root user, you attempt to start MySQL and find this error in the error log: mysqld: Can’t change dir to '/var/lib/mysql/' (Errcode: 13 - Permission denied)
The user option is set to mysql in /etc/my.cnf. What is the reason for this error and how do you fix it?
A、
You forgot to add datadir=/var/lib/mysql to the configuration.
B、
You should not run the command as root. Running the command as the mysqladmin user will solve the problem
C、
You cannot start MySQL without creating service values first. Check the permission for service values in /etc/init.d to see if the internet service daemon is working and try again.
D、
You forgot to add password variables to the configuration so it cannot change the user.
E、
The owner of /var/lib/mysql is root. Change the ownership to mysql and retry the command
单选题 A simple master-to-slave replication is currently being used.This information is extracted from the SHOW SLAVE STATUS output:
You execute a "SHOW CREATE TABLE mytable" on the slave:
You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. 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 GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"
C、
SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
D、
SET GLOBAL enforce_gtid_consistency=ON
E、
SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
单选题 Why should you be selective when granting the PROCESS privilege to an account?
A、
It allows a client to see another user's queries with the SHOW PROCESSLIST command.
B、
It allows a client to control running process on a server
C、
It allows a client to process scripts.
D、
It allows the use of stored routines.
单选题 Which statement describes how the relay log works?
A、
It stores changes on the master, and relays them to the slave.
B、
It maintains a record of available master binary logs and the current executed log position.
C、
When a slave receives a change from the master, it is processed first, and then recorded in the relay log.
D、
When a slave receives a change from the master, it is recorded in the relay log first and processed later.
单选题 The /myfolder/my.cnf file has option set: [mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld] log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using.
Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line: mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?
A、
MySQL starts and Binary Logging is enabled.
B、
MySQL fails to start due to the conflicting options in the configuration files.
C、
MySQL fails to start due to conflicting options on the command line.
D、
MySQL starts but Binary Logging is disabled.
2020-07-14
共170道
