HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?
Answer Posted / 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 |
Post New Answer View All Answers
What are different types of receipt reversals ? Explain them : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is chargeback invoice? How do we create it? : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is mrc and what is its use? : oracle accounts receivable
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Are These Dff's Flexible?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
difference of using cursor for loop and open,fetch,close.which one is better
What are different types of transactions in ar? : oracle accounts receivable
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable