HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?
- 4 Answers
- 9123 Views
- I also Faced
- E-Mail Answers
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 Cross Validation & Adi?
8. Supporting AP, AR and GL?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
What view would you use to determine free space in a tablespace?
what is semphore explian it?
can we use lexical perameter in oracle plsql if yes how
default triggers available for reports
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
How to clone the database using RMAN back
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What are different types of receipt reversals ? Explain them : oracle accounts receivable
what is difference between inner join & nested query or subqueries
Explain the payment term in ar. : 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
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
