1z0-888 MySQL 5.7 Database Administrator Practice Questions

They are used to set up the initial binary log files.

They are used to prevent data corruption.

They are used to prevent data theft.

They are used to set up a replication slave.

They are used to recover data.

They are used to set up a test system.

There are three indexes on the table.

There is a redundant index on the dept_no column.

The secondary indexes are optimized for unique key look-ups.

The values on the emp_no column must be unique.

The selectivity of the dept_no column is the best of the indexed columns.

There is a redundant index on the emp_no column.

SET PASSWORD FOR ‘backup’@’localhost’ = ‘password’;

SET PASSWORD = ‘password’;

SET PASSWORD FOR ‘backup’@’localhost’ = PASSWORD('password’)

ALTER USER USER() IDENTIFIED BY ‘password’;

CREATE USER ‘backup’@’localhost’ IDENTIFIED BY ‘password’;

ALTER USER ‘backup’ IDENTIFIED BY ‘password’;

ALTER USER ‘backup’@’localhost’ IDENTIFIED BY ‘password’;

using GRANT ... REQUIRE X509 AND REQUIRE ISSUER 7C=.....’ AND REQUIRE SUBJECT 7C=.....’

using GRANT USAGE, X509,....... ON . TO user@remotehost IDENTIFIED BY ‘secret_password’

using GRANT ... REQUIRE SSL for a secure connection

using GRANT USAGE, SSL,.....ON . TO user@remotehost IDENTIFIED BY ‘secret_password’

The mysql user needs a login and its home directory must be the base directory of the installation.

The OS needs to allow logging in as mysql so that administrative tasks can be performed.

This prevents mysqld from starting when standard startup scripts are used.

This prevents creation of a command shell with the mysql account, while allowing mysqld to run.

log-master-updates

rpl-recovery-rank

server-id

enable-master-start

log-bin

master-logging

battery-backed locally-attached RAID 5 array

iSCSI Lun

SAN (Fibre Channel) Lun

NFS (Networked File System) mount

It caches index blocks for MylSAM tables only.

It caches index blocks for all storage engine tables.

It is a global buffer.

It is set on a per-connection basis.

It caches index blocks for InnoDB tables only.

when you want to check a tables structure to see if it may have been damaged and needs repair

when you need to find out why a query is taking a long time to execute

when you want to update index distribution statistics

after large amounts of table data have changed

The cluster can be operated in multimaster mode with conflict detection for DML statements.

All MySQL client programs and connectors can be used for executing queries.

It provides fully synchronous replication between the nodes.

There is support for automatic failover when one node fails.

The data is automatically shared between the nodes.

Each query will be executed in parallel across the nodes.