Oracle 1z0-182 Question Answer
Which statement is true about database links?
A database link can be created only between two Oracle databases.
Private database link creation requires the same user to exist in both the local and the remote databases.
A public database link can be created only by SYS.
A database link created in a database allows a connection from that database's instance to the target database's instance for selecting schema data.
A public database link can be used by any user allowing remote database instance connection for selecting schema data.
A.False. Links can connect to non-Oracle DBs via gateways.
B.False. No such user requirement; authentication is separate.
C.False. Any user with CREATE PUBLIC DATABASE LINK can create one.
D.True. Links enable remote schema access (e.g., SELECT * FROM emp@remote).
E.False. Public links allow access, but privileges on remote objects are needed.
TESTED 16 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved