Interested to Buy Any Domain ? << Click Here >> for more details...
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?
- 4 Answers
- 9977 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kaleel
Each row of data in a table is uniquely
identified by a primary key
• You can logically relate data from multiple
tables using foreign keys
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / manoj byregowda
Primary key- A column (or columns)in a table which makes every row in table unique. eg - EMPLOYEE table, EMPID is column which is unique.
Foreign Key - A column (or columns) in table Whose value References to primary key of another table OR ( A column which derives its value from another tables primary key.)
eg - EMP table EMPID is PK and DEPTNO is FK.
DEPT table DEPTID is pk.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mkjmkumar
Primary Key Column or Columns Containt Unique Values.
Foreign Key Column or Columns does not contains Unique
Values in Table
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / mukhtiar ahmed
primary key
A column (or columns) in a table that makes the row in the
table distinguishable from every other row in the same
table.
foreign key
A column (or columns) in a table that draws its values from
a primary or unique key column in another table. A foreign
key assists in ensuring the data integrity of a table.
| Is This Answer Correct ? | 1 Yes | 3 No |
8. Supporting AP, AR and GL?
How do you use trigger to create mutating state of table
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
How would you force a log switch?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
what are the advantages of Oracle over other databases..? please give me reply...
What is database schema?
what is difference between inner join & nested query or subqueries
1. What is PO rate variance gain and loss?
Explain the payment term in ar. : oracle accounts receivable
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
Compare and contrast TRUNCATE and DELETE for a table.
Oracle General 
