Multiple choice

Dynamic data replication is the way in which updating or inserting records in remote database through _________.

  1. stored procedures

  2. cursors

  3. database procedures

  4. database triggers

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Dynamic data replication to remote databases is achieved through database triggers, which can automatically propagate DML changes to remote tables. Stored procedures and database procedures must be explicitly invoked. Cursors are query result iterators, not replication mechanisms. Triggers provide the automatic, event-driven replication needed.