OA. free
Free
Micron Core Computer Science Core Computer Science Medium

Question 27 Which of the schema given in options owns an object that will be replicated and...

Micron technical mcq question, verified with a worked answer. Free to practise - no sign-up.

Question 27

Which of the schema given in options owns an object that will be replicated and also owns schedules for propagation of replicated objects?

Choose one option.
Show answer & explanation
Answer: D. REPADMIN

REPADMIN is the administrative replication schema that owns both replicated objects and the schedules that control their propagation. REOPERATOR handles replication operations, REPUSER manages user access to replicated data, and REPPROXY acts as an intermediary for replication, but only REPADMIN has ownership of the replication infrastructure including objects and their propagation schedules.

Step-by-step Derivation:
In Oracle database replication architecture, schemas are categorized by their roles: REOPERATOR performs operational tasks on replication, REPUSER consumes replicated data, REPPROXY facilitates replication communication, and REPADMIN administers the entire replication environment. The question asks which schema owns both the replicated objects themselves AND the schedules governing their propagation—this dual ownership is an administrative responsibility, which is the purview of REPADMIN schema.