Oracle
1Z0-883 · Question #87
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…
The correct answer is B. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table. E. Use the replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the ?replicate-do-db, -- replicate-do-table, or replicate-wild-do-table option with the value equal to
- BChange the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
- CStop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
- DSet binlog_format=MIXED with the replicate-ignore-temp-table option.
- EUse the replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and
How the community answered
(53 responses)- A4% (2)
- B75% (40)
- C6% (3)
- D15% (8)
Community Discussion
No community discussion yet for this question.