[Q83-Q97] Use Real 1Z1-888 - 100% Cover Real Exam Questions [Jun-2022] : Valid Premium Exam : http://premium.validexam.com

NEW QUESTION 83
What is the order of tables shown in an EXPLAINoutput?

It lists tables from the smallest to the largest.

It lists tables in the order in which their data will be read.

It lists tables from the most optimized to the least optimized.

It lists tables in the order in which they are specified in the statement that is being explained.

NEW QUESTION 84
You have just created a replication slave from a backup of the master made with mysqldump:

You try to log in to the slave with the application user, but fail as follows:

The login works on the master.
Which two changes to the process can fix the issue?

After the restore, log in to the database and execute FLUSH PRIVILEGES.

Use the –flush-privilegeswith mysqldump.

Add a second dump for the ‘mysql’ database; –all-databasesdoes not include it.

Use the –grantsoption to include GRANTstatements in the dump.

NEW QUESTION 85
These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

mysql> CREATE USER ’employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;mysql> CREATE USER ”@” IDENTIFIED BY ‘valid_password’ WITH PROXY ’employee’@’localhost’;

mysql> CREATE USER ’employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;mysql> GRANT PROXY ON ’employee’@’localhost’ TO ‘robert’@’localhost’;

mysql> CREATE USER ‘robert’@’localhost’ IDENTIFIED BY ‘secret_password’;mysql>CREATE USER ’employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;

mysql> CREATE_USER ”@” IDENTIFIED WITH authentication_pam ACCOUNT LOCK;mysql> CREATE USER ’employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;mysql> GRANT PROXY ON ’employee’@’localhost’ TO ”@”;

NEW QUESTION 86
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)

The salve has two intermediate relay slaves connected to it.

The slave is configured with slave_parallel_workers = 4

At most, two schemas are being updates concurrently.

THREAD_ID 21 has stopped running.

The slave cannot process the relay log fast enough to use all threads.

The server needs more cores to use all slave threads.

NEW QUESTION 87
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

Run the create_system_tables.sql file

Run the mysql_unpack.sql file

Invoke mysqld with the –initialize option.

Invoke mysql with the –initialize option.

NEW QUESTION 88
When you examine a new MySQL installation with default configuration, you find a file called ibdata1in the database directory. Which two statements are true about this file? (Choose two.)

it contains the binary log.

it contains a general tablespace.

it is the default location for all new tables that you create.

it contains the system tablespace.

it contains the redo log.

it contains the undo log.

NEW QUESTION 89
You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

the mysql_upgrade script

the mysql client with the –ignore-password-hashing option

the mysql_secure_installation script to update server security settings

the mysql client with the –enable-cleartext-plugin option

the install plugin command for the mysql_cleartext_password plugin

NEW QUESTION 90
Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysqlclient to connect to the server and send clear text passwords?
(Choose two.)

mysql –protocol=PLAIN -uroot -p -h dbhost.example.com

INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;

export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’

SET GLOBAL mysql_cleartext_passwords=1;

mysql –enable-cleartext-plugin -uroot -p -h dbhost.example.com

NEW QUESTION 91
A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERTstatement commits.
Which list of locations is in the sequence of disk writes for this transaction?

binary log, redo log, doublewrite buffer, and tablespace

redo log, binary log, doublewrite buffer, and tablespace

doublewrite buffer, redo log, tablespace, and binary log

redo log, doublewrite buffer, tablespace, and binary log

NEW QUESTION 92
You are using the mysqldumpslow utility to view the contents of the slow query log.
You notice the letter N and the character string `S’ in a number of locations in the output.
What does the N indicate?

the number of times the statement was executed

an abbreviation for NULL in a statement

the name of the user issuing the statement

an abstracted substitution for numbers indicated in WHERE clauses

NEW QUESTION 93
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?

to allow the remaining events to be processed on the slave while not receiving new events from the master

to allow a backup to be created under reduced load

to allow for point-in-time recovery on the slave

to prevent schema changes from propagating to the slave before they are validated

to prevent any transaction experiencing a deadlock

NEW QUESTION 94
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be “rolled forward” to provide all the latest datA.
The SHOW SLAVE STATUS indicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?

STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE
‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

NEW QUESTION 95
You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default –basedir value) for your operating system. Which step should you perform before defining your own databases and database tables?

Execute a command with a minimal form of: mysql –initialize

Create a configuration file containing default-storage-engine=InnoDB.

Set an exception in the host machine’s firewall to allow external users to talk to mysqld.

Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.

NEW QUESTION 96
Which MySQL utility copies the master instance to a slave instance on the same host?

mysqlfailover

mysqldbcopy

mysqlrplsync

mysqlserverclone

NEW QUESTION 97
A general purpose MySQL instance is configured with the following options:
–slow-query-log
–long-query-time=.0001
–log-queries-not-using-indexes
–log-slow-admin-queries
–general-log
–log-bin
–binlog-format=STATEMENT
–innodb-flush-log-at-trx-commit=1
Which three statements are true for most workloads? (Choose three.)

The Slow Query Log records more data than the General Query Log.

The General Query Log records more data than the Slow Query Log.

The Slow Query Log records more data than the Binary Log.

The Binary Log records more data than the General Query Log.

The Binary Log records more data than the Slow Query Log.

The General Query Log records more data than the Binary Log.