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

Suggested Answer: A 🗳️

by Dhanushka at July 16, 2023, 7:02 a.m.

Comments

Submit Cancel

nkanike1

6 months, 3 weeks ago

Answer A

upvoted 1 times

...

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

...