Practice 1Z0-888 Exam Online

Question 1

Consider:

Other-Image-27e18e2aa-4a53-4473-9634-03ec3a7131fa

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.

Answer: A

Question 2

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

Answer: A

Question 3

A MySQL database uses all InnoDB tables and is configured as follows;

Other-Image-2e5b2c143-d60d-4e67-bf3f-0d7a78ed2db8

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this? (Choose two.)

A : --skip-opt

B : --lock-all-tables

C : --create-apply-log

D : --single-transaction

E : --master-data

Answer: A,B

Question 4

Consider the join_buffer_size parameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)

A : The value should be increased if the client performs several SELECT operations.

B : The join buffer is set per connection.

C : The join buffer is used to process sorts when complex joins are being performed.

D : The value should be increased from the default if the query joins large rows without using an index.

E : The join buffer is global and can be changed only by restarting the server.

Answer: C,D

Question 5

You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)

A : log-master-updates

B : rpl-recovery-rank

C : server-id

D : enable-master-start

E : log-bin

F : master-logging

Answer: A,C

Name:	MySQL 5.7 Database Administrator
Exam Code:	1Z0-888
Certification:	Oracle MySQL
Vendor:	Oracle
Total Questions:	125
Last Updated:	Apr 24, 2024

Oracle 1Z0-888