Weekend Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the...

Oracle 1z0-888 Full Course Access
Oracle 1z0-888 View All Questions

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.)

A.

Set binlog_format=MIXED with the --replicate-ignore-temp-table option.

B.

Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.

C.

Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

D.

Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

E.

Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

1z0-888 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now 1z0-888 pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
A MySQL instance has this configuration values set:A transaction involving a single InnoDB INSERT statement...
You are using the Performance Schema to investigate replication on a slave which has a...
Previous