Oracle Exam 1Z0-888 Topic 14 Question 6 Discussion

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

Question #: 6
Topic #: 14

On a master server that is using statement-based replication, a table of log data has become very large.

You decide to delete 100,000 rows.

Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

AChange the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.

BIf the data modification is non-deterministic, the query optimizer will resolve any potential issues.

CUse the LIMIT clause to limit the deletion to 100,000 rows.

DUse the LIMIT clause in conjunction with the ORDER BY clause.

Show Suggested Answer

Suggested Answer: A, D

by Donte at May 06, 2022, 04:35 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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