Database link types - Oracle Distributed Database concepts

Q.  How many types of database links does the oracle database lets you create?
- Published on 27 Jul 15

a. 2
b. 3
c. 4
d. 5

ANSWER: 3
 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - Oracle Database lets you create private, public, and global database links.

    - These basic link types differ according to which users are allowed access to the remote database:

    - Private - Creates link in a specific schema of the local database. Only the owner of a private database link or PL/SQL subprograms in the schema can use this link to access database objects in the corresponding remote database.

    - Public - Creates a database-wide link.
    - All users and PL/SQL subprograms in the database can use the link to access database objects in the corresponding remote database.

    - Global - Creates a network-wide link.
    - When an Oracle network uses a directory server, the directory server automatically create and manages global database links (as net service names) for every Oracle Database in the network.
    - Users and PL/SQL subprograms in any database can use a global link to access objects in the corresponding remote database.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)