Winter Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Legit 1z0-888 Exam Download

Page: 2 / 5
Total 124 questions

MySQL 5.7 Database Administrator Questions and Answers

Question 5

A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERT statement commits.

Which list of locations is in the sequence of disk writes for this transaction?

Options:

A.

binary log, redo log, doublewrite buffer, and tablespace

B.

redo log, binary log, doublewrite buffer, and tablespace

C.

doublewrite buffer, redo log, tablespace, and binary log

D.

redo log, doublewrite buffer, tablespace, and binary log

Question 6

You have created a new user with this statement:

CREATE USER ‘erika’@’localhost’ IDENTIFIED BY ‘first#1Pass’ PASSWORD EXPIRE;

What is the outcome?

Options:

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.

Question 7

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

Options:

A.

binlog_cache_size=1024 is too small and transactions are lost.

B.

binlog_format=STATEMENT and a non-deterministic query was executed.

C.

enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

D.

The sync_relay_log=1000 setting on the slave is too small.

E.

sync_binlog=0 and the master server crashed.

Question 8

Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

Options:

A.

Physical backups can be used to recover from data corruption.

B.

Logical backups are human-readable whereas physical backups are not.

C.

Logical backups are always larger than physical backups.

D.

Physical backups are usually slower than text backups.

E.

Physical backups are usually faster than text backups.

Page: 2 / 5
Total 124 questions