1Z0-888 Online Practice Questions and Answers

Consider: Which statement best describes the meaning of the value for the key_len column?

A. It shows how many bytes will be used from each index row.

B. It shows the number of characters indexed in the key.

C. It shows the total size of the index row.

D. It shows how many columns in the index are examined.

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? (Choose two.)

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

B. to allow a backup to be created under reduced load

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

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

E. to prevent any transaction experiencing a deadlock

Which three allocate memory per thread in MySQL? (Choose three.)

A. query cache

B. thread cache

C. read buffer

D. internal temporary table

E. sort buffer

F. InnoDB buffer pool instance

Consider that local disk files are accessible via MySQL with commands such as: mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

A. executing REVOKE LOAD FROM *.*

B. setting the --local-service=0 option when starting mysqld

C. executing REVOKE FILE FROM *_*

D. executing REVOKE FILE ON *_* FROM ` `@'%'

E. setting the --local-infile=0 option when starting mysqld

F. setting the --open-files-limit=0 option when starting mysqld

Which three statements correctly describe MySQL InnoDB Cluster? (Choose three.)

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

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

C. It provides fully synchronous replication between the nodes.

D. There is support for automatic failover when one node fails.

E. The data is automatically shared between the nodes.

F. Each query will be executed in parallel across the nodes.

Consider the table people with the definition:

The application uses a query such as:

SELECT * FROM people WHERE YEAR(Birthday) = 1980;

The query is not using an index.

Which two methods can be used to allow the query to use an index? (Choose two.)

A. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

B. Add a functional index for YEAR(Birthday).

C. Execute ANALYZE TABLE to update the index statistics.

D. Add a generated column calculating YEAR(Birthday) and index that column.

E. Add FORCE INDEX (Birthday) to the query.

You have created a new user with this statement:

CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE;

What is the outcome?

A. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.

B. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.

C. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.

D. You receive a syntax error that indicates that you cannot set a password and expire it at the same time.

What three are correct statements about MySQL backups? (Choose three.)

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

B. They are used to prevent data corruption.

C. They are used to prevent data theft.

D. They are used to set up a replication slave.

E. They are used to recover data.

F. They are used to set up a test system.

You have been tasked with creating a QA MySQL instance on a DB host, which already has one large instance in /var/lib/mysql/ running as the mysql user. The MySQL configuration file for the existing instance includes:

The default instance was installed using the OS package manager. The latest binaries for both client and server are already in ENV PATH.

The new instance will run as a different user from the existing instance for security purposes. You create the new data directory successfully and move on to initialize the new DATADIR.

You verify the output to confirm the operation's success:

[mysqlQA@linux /var/lib/]$ mysqld --initialize --datadir=/var/lib/mysql_QA 2>and1 | tail -n3

2018-05-03T12:16:10.928809Z 0 [ERROR] Could not open file '/var/log/mysqld.log' for error logging:

Permission denied

2018-05-03T12:16:10.928841Z 0 [ERROR] Aborting

[mysqlQA@linux /var/lib/]$

The initialization of the instance has failed.

What would you do to enable the initialization to succeed?

A. Pass --log-error=/var/lib/mysql_QA/mysqld.log.

B. Use mysql_install_db.

C. Use --no-defaults to ignore the existing config file in the default PATH.

D. Change permissions on /var/log/mysqld.log to allow writes.

Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?

A. mysqld -e 'shutdown'

B. service mysqld stop

C. mysqladmin shutdown

D. mysql -e 'shutdown'