Exam 1z0-082 topic 1 question 111 discussion

Which statement is true about database links? A. Private database link creation requires the same user to exist in both the local and the remote databases. --> False. B. A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa. --> True C. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance. --> False, you don't see any schema. D. A public database link can be created only by SYS. --> False E. A database link can be created only between two Oracle databases. --> False, you can create a db link to itself! :-)

b is correct

B PUBLIC does not means a user can use any schema. It means other users can use db link what you made it. When you create a private or public database link, you can determine which schema on the remote database the link will establish connections to by creating fixed user, current user, and connected user database links. https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-a-distributed-database.html#GUID-B5950167-35F8-4C88-B063-382E0290CB53