In a design situation, there are multiple character sets that can properly encode your data.Which three should influence your choice of character set?
What are three actions performed by the mysql_secure_installation tool?
Consider the query:Mysql> SET @run = 15;Mysql> EXPLAIN SELECT objective, stage, COUNT (stage)FROM iteminformation -WHERE run=@run AND objective=7.1GROUP BY objective,stage -ORDER BY stage;The iteminformation table has the following indexes;Mysql> SHOW INDEXES FROM iteminformation:This query is run several times in an application with different values in the WHERE clause in a growing data set.What is the primary improvement that can be made for this scenario?
Consider typical High Availability (HA) solutions that do not use shared storage.Which three HA solutions do not use shared storage?
Which three statements are characteristic of the MEMORY storage engine?
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-8Auto _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?
