You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information. The…

A cluster is a local storage optimization that physically collocates rows from related tables sharing common columns in the same data blocks, and provides no mechanism for accessing a remote database.

A database link is a schema object stored in the local database that enables users to connect to and query objects on a remote Oracle database instance. When a user references an object through a database link, Oracle transparently authenticates to the remote database (SEMP) and retrieves the data. This allows the accounts payable user to cross-reference employee data from SEMP without any data duplication or migration.

A mapping table is not a standard Oracle schema object for remote data access - it is used internally by certain replication and materialized view log features and does not enable cross-database connectivity.

A materialized view can store a local snapshot of remote data but actually requires an underlying database link to function, and it provides a point-in-time copy rather than live access to the remote database.