HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?
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 standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
How to find locks exists in a table or not?
can we use lexical perameter in oracle plsql if yes how
Whats the purpose of using Nextval while creating the sequence.
Why more redos are generated when the oracle database is in begin backup mode?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
When a user process fails, what background process cleans up after it?
default triggers available for reports
How would you determine who has added a row to a table?
What is autocashrule set? : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable