Q
Which statement creates a database link?
-
A
CREATE LINK remote_db TO 'orcl2';
-
B
ALTER DATABASE ADD LINK remote_db;
-
C
CONNECT DATABASE remote_db;
-
D
CREATE DATABASE LINK remote_db CONNECT TO hr IDENTIFIED BY pwd USING 'orcl2';
Correct Answer:
D. CREATE DATABASE LINK remote_db CONNECT TO hr IDENTIFIED BY pwd USING 'orcl2';
Explanation:
The USING clause gives the net service name defined in tnsnames.ora.
