Q131.You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.

Examine the message sequence generated during the first start of MySQL 8.0.18:

。。。[System]。。。/usx/sbin/mysqld (mysqld 8.0.18-commercial) starting as process 2754

。。。[System]。。。Starting upgrade of data directory. .

。。。[ERROR]。。。。Table upgrade required. Please do ‘’REPAIR TABLE ‘columns_ priv'" or dump/reload to fix it!

。。。[ERROR]。。。Table upgrade required. Please do "REPAIR TABLE ‘event’" or dump/reload to fix it!

。。。[ERROR]。。。Table upgrade required. Please do "REPAIR TABLE ’proc'" or dump/reload to fix it!

。。。[ERROR]。。。Table upgrade required. Please do "REPAIR TABLE ’proxies_ priv’" or dump/reload to fix it!

。。。[ERROR]。。。Table upgrade required. Please do "REPAIR TABLE ‘tables_ priv’" or dump/reload to fix it!

。。。[ERROR]。。。Failed to open mysql.event Table.

。。。[ERROR]。。。Failed to open mysql.proc Table.

。。。(ERROR]。。。Failed to Populate DD tables.

。。。[ERROR]。。。Aborting

。。。[System] 。。。 /usr/sbin/mysqld: shutdown complete (mysqld 8.0.18-commercial) MySQL Enterprise Server - Commercial.

Which step or set of steps will resolve the errors?

A)Start mysqld again using the --upgrade=FORCE option.

B)Go to the <datadir>/mysql directory and execute: myisamchk --update-state columns_ priv event proc proxies_ priv tables_ priv.

C)Execute: mysqlcheck --repair mysql columns_ priv event proc proxies_ priv tables_ priv.

D)Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.

E)Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_ priv.

Answer:A

Q132.You plan to upgrade your MySQL 5.7 instance to version 8.

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?

A)It documents any problems with your 5.7 tables to make them ready to upgrade to 8.

B)It fails because the operation name must be in camelCase.

C)It fixes any problems with your 5.7 tables to make them ready to upgrade to 8.

D)It is mandatory to clear the history of prior results before executing this process a second time or later.

E)It fails because checkForServerUpgrade must be executed only within an active shell session as a method of the util object.

F)It is mandatory to run this command so that MySQL 8.0 software's auto-upgrade process has the details it needs to operate properly.

Answer:A

Q133.Database test contains a table named city that has the InnoDB storage engine.

CREATE TABLE ‘city' (

'ID' int NOT NULL AUTO_ INCREMENT ,

‘Name’ char(35) NOT NULL DEFAULT '',

‘Countrycodechar’(3) NOT NULI DEFAULT '',

‘District' char (20) NOT NULI DEFAULT ' ',

‘Population' int NOT NULI DEFAULT '0',

PRIMARY KEY('ID') ,

KEY 'CountryCode' ( ' Countrycode’ )

) ENGINE= InnoDB TABLESPACE=innodb_ file_ per_ table;

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

A)city.MYD, city.MYI, and city.sdi

B)city.ibd

C)city. ibd and city.sdi

D)city. ibd and city. frm

E)city.ibd, city. frm, and city.sdi

Answer:B

Q134.Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure?

A)cluster addInstance 0)

B)dba.configureLocalInstance()

C)dba. checkInstanceConfiguration 0

D)cluster .setPrimaryInstance()

E)dba. configureInstance 0)

F)dba.createCluster()

G)cluster . forceQuorumUsingPartitionOf()

Answer:DG

Q135.Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server?

A)IPv4

B)SOCKET

C)MEMORY

D)PIPE

E)IPv6

F)FILEO

G)TCP

H)DIRECT

Answer:BCDG

Q136.Which two authentication plugins require the plaintext client plugin for authentication to work?

A)LDAP authentication

B)SHA256 authentication

C)Windows Native authentication

D)PAM authentication

E)MySQL Native Password

F)LDAP SASL authentication

Answer:AD

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

A)/usr

B)/usr/mysql

C)/etc/my.cnf

D)/var/lib/mysql

E)/usr/bin

Answer:D

Q138.You are using mysql check for server maintenance.

Which two statements are true?

A)The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

B)The mysqlcheck --repair --al1-databases command can repair an InnoDB corrupted table.

C)The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions

D)The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

E)The mysqlcheck --optimize --all-databases command reclaims free space from table files.

Answer:DE

Q139.You plan to install MySQL Server by using the RPM download.

Which two statements are true?

A)You must manually initialize the data directory.

B)You can provide the root password interactively.

C)The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.

D)MySQL uses the RPM relocatable installation target feature.

E)You can find the root password in the error log after the first start.

F)The functionality is split among several RPM package files.

Answer:EF

Q140.Examine this MySQL Shell command:

dba. rebootClusterFromCompleteOutage ()

Which two statements are true? (Choose two.)

A)It reconfigures InnoDB Cluster if the cluster was stopped.

B)It performs InnoDB Cluster instances rolling restart.

C)It only starts all InnoDB Cluster instances.

D)It is not mandatory that all instances are running and reachable before running the command.

E)It stops and restarts all InnoDB Cluster instances and initializes the metadata.

F)It only stops and restarts all InnoDB Cluster instances.

G)It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

Answer:AD