Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 139042 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How does one get the view definition of fixed views/tables?
What is the usage of merge statement?
How to drop a tablespace?
State some uses of redo log files?
State the difference between a primary key and foreign key?
what are bitmap indexes? How does they work?
types of indexes and the rationale behind choosing a particular index for a situation.
In what script is snap$ created? In what script is the scott/tiger schema created?
Explain oracle data types with examples?
What is a sub query and what are the different types of subqueries?
How can I introduce multiple conditions in like operator?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is an Oracle Instance?
How a database is related to tablespaces?
What is open database communication (odbc) in oracle?
