Oracle Exam 1Z0-888 Topic 14 Question 69 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 69
Topic #: 14

You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:

USE prices;

UPDATE sales.january SET amount=amount+1000;

An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.

Which statement is true? (Choose two.)

AYou would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.

BThe changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW

CThe statement would fail because you cannot update more than one row at a time when using --binlog-format = ROW.

DNothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.

ENothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

Show Suggested Answer

Suggested Answer: D

by Novella at Feb 02, 2023, 04:50 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-888 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!