Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the difference between primary key & foreign key?

Answer Posted / vaziuddin shaik

PRIMARY KEY
-------------
Primary key is a column in a table which is having unique
values......and it does not contain null values and
duplicate values...........

FOREIGN KEY
-------------
Foreign key is a column in a table which act as reference to
another table.....and it may contain null and duplicate
values.....(or)it may not contain null and duplicate
values...........

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find out what oracle odbc drivers are installed?

1040


What are the predefined tablespaces in a database?

1079


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2058


What is a nvl function? How can it be used?

1026


What are a query and state the different types of queries and their uses?

1011


How to start instance with a minimal initialization parameter file?

1037


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1986


How to shutdown your 10g xe server from command line?

1084


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2117


how the indexes are stored in the Oracle Database?

2269


What is the difference between count (*), count (expression), count (distinct expression)?

1002


How to use "for" statements in oracle?

1072


How to empty your oracle recycle bin?

1018


What is set verify off in oracle?

1096


Can you assign multiple query result rows to a variable?

984