Database Links & Replication — Test 1

Correct Answer: A. SELECT * FROM global_name;
Explanation: With GLOBAL_NAMES=TRUE, a database link name must match the remote database's global name.

Correct Answer: D. DROP DATABASE LINK remote_db;
Explanation: A private link is dropped by its owner; PUBLIC links need DROP PUBLIC DATABASE LINK.

Correct Answer: A. Yes, e.g. UPDATE emp@remote_db SET salary = 5000 WHERE id = 5;
Explanation: Remote DML works, and the transaction becomes distributed when it commits.

Correct Answer: A. Connected-user link
Explanation: A connected-user link connects to the remote database using the same username and password as the current user.

Correct Answer: C. Oracle Database Gateways (Heterogeneous Services)
Explanation: Gateways translate SQL and data types so non-Oracle systems appear like remote Oracle databases.

Correct Answer: C. Oracle GoldenGate
Explanation: GoldenGate captures changes from redo logs and delivers them to other systems.

Correct Answer: A. Materialized view logs to apply only changes
Explanation: COMPLETE refresh re-executes the query; FAST applies changes recorded in MV logs.