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

Exam 1z0-908 All Questions

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

Exam 1z0-908 topic 1 question 16 discussion

Actual exam question from Oracle's 1z0-908
Question #: 16
Topic #: 1
[All 1z0-908 Questions]

Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?

  • A. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
  • B. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
  • C. mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
  • D. mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Dhanushka at July 16, 2023, 7:02 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
nkanike1
3 months, 2 weeks ago
Answer A
upvoted 1 times
...
FelipeK
5 months ago
Selected Answer: A
The correct command to copy binary log events for the ‘mydb1’ schema to a different schema name ‘mydb2’ is mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql1. So, the correct answer is A. This command updates a database with a different name than the original
upvoted 1 times
...
Dhanushka
6 months ago
Selected Answer: A
It does not tell read from remote server
upvoted 2 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