Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 137455 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gajendra jain
A table can have only one Primery key but it can have any number of Foreign key.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / anand
Primary key is used to identify a row in a table and it
doesnot allow null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / abhishek ranjan
The main diference between primary key and the foreign key is that the primary key is a column or a set of columns that can be used to uniquely identify a row in a table while the foreign key is a column or a set of columns that refer to a primary key or a candidate key of another table. Foreign key mainly provides a method to link information in several tables. Another difference is that a table can have a single primary key, but it can have multiple foreign keys that can reference different tables.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / leang heng
Primary Key is a column or group of columns that determine
in each Record to make not null.
Foreign Key is Column that provide Relationship to Primary
Key between Entities or Table.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / praneeth
primary key helps in uniquely identifying the records in a table
a foreign key is a field that points to the primary key of another table which links one table to another table
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / aarti
Primary Key : It is a unique key of the table.Unique for
each record in the table(e.g ID).
Foreign Key : When a primary key is used as a reference key
in another table then it is called as a foreign key.It is
used to link two tables.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / keyman
Foreign key = Florida Keys (Keys in a foreign land)
Primary Key = The main key you use to enter you home
| Is This Answer Correct ? | 12 Yes | 36 No |
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
Difference between an implicit & an explicit cursor.?
How to list all indexes in your schema?
Can a parameter be passed to a cursor?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
Which is faster join or subquery in oracle?
What is the difference between pre-select and pre-query?
What is the difference between post-database commit and post-form commit?
What is an Extent ?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
What is recycle bin in Oracle?
What is oracle used for?
Oracle General 
