HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?
- 4 Answers
- 9082 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 |
what are the API of GL,PO,AP
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
please explain about oracle
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
WHAT IS CARTESIAN PRODUCT?
Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Explain the payment term in ar. : oracle accounts receivable
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
what is the link between suppliers and banks in ap module in oracle apps? And also query?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
Oracle General 
