How to create a database link?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

130. How to create a database link?

A database link is an object in the local database that allows you to access objects on a remote database or to mount a secondary database in read-only mode.
CREATE [PUBLIC] DATABASE LINK dblink
[CONNECT TO user IDENTIFIED BY password]
[USING ‘connect_string’]

(Continued on next question...)

Other Job Interview Questions

• What are the built-ins used for Creating and deleting groups?
• What are the built-ins used for finding object ID functions?
• Give two examples of referential integrity constraints.
• Give two methods you could use to determine what DDL changes have been made.
• Give two examples of how you might determine the structure of the table DEPT.
• What is new_form built-in?
• What are clusters?
• How to create a database link?
• What is Parallel Server?
• Define Transaction?
• More...