Multiple choice

After adding a new object to a replication group, what do you need to do before it can be replicated to other master sites?

  1. Create a snapshot log for the object.

  2. Enter the object into the deferred transaction queue.

  3. Generate replication support for the object.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

After adding an object to a replication group, you must generate replication support to create the necessary triggers, procedures, and packages that track changes and propagate them to other master sites. Snapshot logs are for materialized views, and the deferred transaction queue is automatically populated - manual entry is not required.

Keep practicing — related questions