the repication event that is located in the log_file position NNNNN file. Which 

command should you use?

query and output: 

mysql>show global status like `Table_lock8';

（含图）

Which statement is true about InnoDB persistent index statistics?

You are using an existing server with a new configuration.MySQL Server fails to 

start. 

Examine this snapshotofthe errorlog: 

190925 12:49:05 InnoDB:Initializing buffer pool，size 3.0G 

190925 12:49:05 InnoDB:Completed initialization of buffer pool 

InnoDB:Errox;log file./ib logfile0 is of different size 05242880 bytes 

InnoDB: than specified in the cnf file 0 26214400 bytes! 

190925 12:49:05 [ERROR] Plugin 'InnoDB'init function returned error. 

190925 12:49:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE 

failed 

190925 12:49:05 [ERROR] Aborting 

190925 12:49:05 [Note] /usr/gbin/mysql d: shtdown complete 

Which action would allow the server to start?

You are using the InnoDB engine and the innodb_file_per_table option is set. 

You delete a significant number of rows of 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 l/O efficiency?

You have a MySQL system with 500 GB of data that needs frequent backups. You 

use a mix of MyISAM and InnoDB storage engines for your data. 

Examine your backup requirement: 

    The MySQL system being backed up can never be unavailable or locked to the 

client applications. 

   The recovery from the backup must work on any system. 

    Only 1 hour of data can be lost on recovery of the backup. 

Which option fulfills all backup requirements? 

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?

t is an on-empty InnoDB table. 

Examine these statements,which are executed in one session: 

BEGIN 

SELECT*FROM t FOR UPDATE; 

Which is true?Choose the best answer

Which step or set of steps can be used to rotate the error log?

Examine this statement,which executes successfully: 

CREATE TABLE world.city( 

    ID int NOT NULL AUTO_INCREMENT, 

    Name char(35) NOT NULL DEFAULT””, 

    Country Code char(3) NOT NULL DEFAULT “ ”, 

    District char(20) NOT NULL DEFAULT“ ”, 

    Population int NOT NULL DEFAULT“ 0 ”, 

    PRIMARY KEY (ID), 

    KEY Country Code (Country Code) 

) ENGINE=InnoDB; 

You want to improve the performance of this query; 

SELECT Name 

   FROM world.city 

   WHERE Population BETWEEN 1000000 AND 2000000; 

Which change enables the query to succeed while accessing fewer rows?

Which condition is true about the use of the hash join algorithm?

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

You want to check the values of the sort_buffer_size session variables of all 

existing connections. Which performance_schema table can you query

An attempt to recover an InnoDB Cluster fails, Examine this set of messages and 

responses: 

host3:3377 ssl Js >dba,rebootclusterFromCompleteOutage() 

Reconfiguring the default cluater from complete outage.. 

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.reboot Cluster From Completa Outage:The active session inatance isn't 

the most updated in comparison with the ONLINE instance of the Clustar’ 

s Please use the most up to date inatance:'hostl:3377*.(RuntimeError) 

Which statement is true?

reduce your log space usage urgently. 

Which two sets of actions when completed will accomplish this?(Choose two.)

A valid raw backup of the shop.customers MyISAM table was taken. 

You must restore the table. You begin with these steps: 

1. Confirm that secure_file_priv='/var/tmp' 

2.mysql>DROP TABLE shop.customers; 

3. shell>cp /backup/customers.MY*/var/lib/mysql/shop/ 

Which two actions are required to complete the restore?(Choose two.)