Examine these statements and output:

Mysql> GRANT PROXY ON accounting@localhost TO ' '@'%' ;

Mysql> SELECT USER(), CURRENT_USER(), @@proxy_user;

（含图）

Which statement is true?

（含图）

Examine this statement, which executes successfully:

（含图）

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?

（含图）

Using Query Analyzer, where do you begin to look for problem queries?

（含图）

Which log will do this by default?

（含图）

Mysqlsh> mycluster.addInstance ( 'ic@ic2' , {memberWeight:25}) mysqlsh> mycluster.addInstance( 'ic@ic3' , {memberWeight:50})

Now examine this configuration setting, which is the same on all nodes:

Group_replication_consistency=BEFORE_ON_PRIMARY_FAILOVER

Which statement is true if primary node ic1 fails?

（含图）

（含图）

Which step or set of steps will resolve the errors?

（含图）

You have installed the 8 build of MySQL Shell.

Examine this command executed from the operating system shell prompt: 

mysqlsh --uri root@localhost:3306 -- util check-for-server-upgrade 

Which statement is true?

（含图）

（含图）

What is the content of the test folder in the data directory?

（含图）

Choose the best answer.

Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

（含图）

Host3: 3377 ssl JS > dba.rebootClusterFromCompleteOutage () Reconfiguring the default cluster 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.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata.

Please use the most up to date instance: ' host1:3377'. (RuntimeError) Which statement is true?

（含图）

Mysql> SHOW FULL PROCESSLIST;

（含图）

Examine this query:

SELECT SUM(m.CURRENT_NUMBER_OF_BYTES_USED、 AS TOTAL

FROM performance_schema.memory_summary_by_thread_by_event_name m INNER JOIN performance_schema.threads t

ON m.THREAD_ID = t.THREAD_ID WHERE t.PROCESSLIST_ID = 10;

What information does this query provide?

（含图）

（含图）

Which value of --ssl-mode will do this?

（含图）

（含图）

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 requirements:

·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?

（含图）

You wish to store the username and password for a client connection to MySQL server in a file on a local file system.

Which is the best way to encrypt the file?

（含图）

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.

Examine the output:

# systemctl start mysqld

Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

# systemctl status mysqld.service mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Thu 2019-12-12 07:54:53 ACDT; 33s ago

Docs: man:mysqld(8) http://dev.mysql.com/a/doc/refman/en/using-systend.html

Process: 2732 Execstart=/usr/ sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/ FAILURE、 Process: 2705 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/ SUCCESS) Main PID: 2732 (code=exited, status=1/FAILURE、

Status: "Server startup in progress "

Dec 12 07:54:49 oel7 systemd[1]: Starting MySQL Server...

Dec 12 07:54:53 oel7 systemd[1] : mysqld.service: main process exited, code=exited, status=1/ FAILURE

Dec 12 07 :54:53 oel7 systemd[1] : Failed to start MySQL Server

Dec 12 07 :54:53 oel7 systemd[1] :Unit mysqld.service entered failed state. Dec 12 07:54:53 oel7 systemd[1]: mysqld.service failed.

What statement is true about the start attempt?

You want to check the values of the sort_buffer_size session variables of all existing connections.

Which performance_schema table can you query?

（含图）

Mysql> SHOW FULL PROCESSLIST;

（含图）

Mysql> SELECT object_type, object_schema, object_name, lock_type, lock_status, owner_thread_id, owner_event_id

-> FROM performance_schema.metadata_locks WHERE object_schema != 'performance_schema' ;

（含图）

Mysql> SELECT thread_id, processlist_id, processlist_user, parent_thread_id

-> FROM per formance_schema.threads WHERE processlist_user=' root';

（含图）

Which connection ID is holding the metadata lock?

（含图）

（含图）

T is a non-empty InnoDB table.

Examine these statements, which are executed in one session:

BEGIN

SELECT * FROM t FOR UPDATE;

Which is true?

（含图）