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

Oracle 1z0-888 Question Answer

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.)

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

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

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

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

1z0-888 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"