Oracle
1Z0-883 · Question #87
1Z0-883 Question #87: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #87. The question stem and answer options stay visible for context.
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
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.