GeekInterview.com
Series: Subject: Topic:
Question: 7 of 89

Private,Public database link

How to give private and public database links ?What is syntax for that ?
What means mutation in oracle??
Asked by: annu.aa | Member Since Oct-2010 | Asked on: Oct 29th, 2010

View all questions by annu.aa

Showing Answers 1 - 1 of 1 Answers
dbxplorer

Answered On : Jul 21st, 2011

View all answers by dbxplorer

Database link is the pointer that allow users to access other user's object in remote database. This is one way communication path using database links.

Private db links:
CREATE DATABASE LINK link_name USING 'remote_database_name';

Public db link:
CREATE PUBLIC DATABASE LINK link_name USING 'remote_database_name';

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Backup and Recovery

Basics

Concepts and Architecture

D2K

Data Access

Database Administration

Database security

Database Tuning

Distributed Processing

General

Memory Management

Oracle Forms 4.0

PL/SQL

Programmatic Constructs

RMAN Interview Questions

Scenarios

SQL

SQL Plus

System Architecture

Interview Coaching

Tell me about a skill you recently acquired or improved.

Do you have any questions that you want to ask?

Describe a time when you had to work under pressure.

Do you seek advice from others when you have a question?

How do you handle workplace problems?

Do you find yourself busy most of the time? Why?

How productive are you?

How do you handle conflict?

How do you handle pressure and stress?

Aptitude Test Preparation Tips

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Oracle Backup and Recovery Interview Questions

Oracle Basics Interview Questions

Oracle Architecture Interview Questions

D2K Interview Questions

Data Access Interview Questions

Oracle DBA Interview Questions

Oracle security Interview Questions

Database Tuning Questions

Oracle Distributed Processing Interview Questions

Oracle Concepts Interview Questions

Oracle Memory Management Interview Questions

Oracle Forms Interview Questions

PL/SQL Interview Questions

Programmatic Constructs Interview Questions

RMAN Interview Questions

Real time Oracle Interview Questions

Oracle SQL Interview Questions

SQL*Plus interview Questions

Oracle System Architecture Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe