Multiple choice

If you want to change a replicated table's structure, how will you proceed?

  1. Open Oracle Enterprise manager and change the table's structure.

  2. Make the change by calling DBMS_REPCAT.ALTER_MASTER_REPOBJECT().

  3. Get any popular third party GUI tool to make the change.

  4. Open SQL*Plus and make the change at each of the replicated sites.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When using Oracle replication (advanced replication), you cannot directly modify replicated table structures with DDL commands. You must use the DBMS_REPCAT.ALTER_MASTER_REPOBJECT() procedure to ensure the change propagates correctly to all replication sites while maintaining replication consistency.

Keep practicing — related questions