×

Special Offer! Sale of the Month | Extra 20% OFF - Ends In Coupon code: TEL20

Free Practice Oracle 1Z0-908 Exam Questions 2025

Stay ahead with 100% Free MySQL 8.0 Database Administrator 1Z0-908 Dumps Practice Questions

Page:    1 / 79      
Total 392 Questions | Updated On: Mar 01, 2021
Add To Cart
Question 1

Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?


Answer: B
Question 2

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.
Which method would use mysqlbinlog for greater consistency?


Answer: B
Question 3

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)


Answer: A,C
Question 4

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:
[mysqld]
Loq-bin
Binrylog_format=ROW
You do not notice the spelling error in binrylog_format and restart your production server.
How does the MySQL server behave with incorrectly spelled options?


Answer: D
Question 5

A MySQL replication master is set up by using global reansaction identifiers(GTIDs). You execute this statement:
mysql> CREATE TABLE datatarget SELECT * FROM datasource;
ERROR 1786 (HY000): CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.
Why is this statment forbiden?


Answer: D
Page:    1 / 79      
Total 392 Questions | Updated On: Mar 01, 2021
Add To Cart

© Copyrights TheExamsLab 2025. All Rights Reserved

We use cookies to ensure your best experience. So we hope you are happy to receive all cookies on the TheExamsLab.