ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-888 All Questions

View all questions & answers for the 1z0-888 exam
Go to Exam

Exam 1z0-888 topic 1 question 16 discussion

Actual exam question from Oracle's 1z0-888
Question #: 16
Topic #: 1
[All 1z0-888 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.
Show Suggested Answer Hide Answer
Suggested Answer: BE 🗳️
by h3clht at Dec. 27, 2022, 9:40 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
h3clht
2 years, 1 month ago
Selected Answer: CE
Correct Answer: CE
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago