Which statement is true about database links?

The primary function of a database link is to act as a pointer within a local database that defines a one-way communication path to a remote database. This allows users and applications connected to the local instance to access schema objects, such as tables and views, in the remote database's instance as if they were local, subject to privileges. This is precisely what option D describes. It is the most accurate and fundamental definition of a database link's purpose among the choices provided.

A. Oracle Database Gateways (formerly Heterogeneous Services) allow the creation of database links to non-Oracle database systems, making this statement false.
B. A private database link can be created with a CONNECT TO clause specifying a different user and password for the remote database.
C. Any user with the CREATE PUBLIC DATABASE LINK system privilege can create a public database link, not just the SYS user.
E. While any user can use a public database link, their access to data is restricted by the privileges granted to the user that the link connects as on the remote database.

Oracle Database Administrator's Guide, 23ai, "20 Managing Distributed Databases", "Managing Database Links". The introduction states, "A database link is a schema object in one database that enables you to access objects on another database."

Oracle Database SQL Language Reference, 23ai, "CREATE DATABASE LINK". The documentation shows the syntax, including the CONNECT TO clause, and lists the required CREATE PUBLIC DATABASE LINK privilege.

Oracle Database Heterogeneous Connectivity User's Guide, 23ai, "1 Introduction to Oracle Database Gateway". This document describes how to use database links to access non-Oracle systems.