Interested to Buy Any Domain ? << Click Here >> for more details...
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?
- 4 Answers
- 10041 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 is the importance of batch source set up in ar? : oracle accounts receivable
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
What is store procedure?and how do u take the values from database and run in scripts?
What is supporting issues GL AP and AR?
Explain the process of recievables in oracle financials. : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is chargeback invoice? How do we create it? : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
What is an Oracle database Full Backup?
Give the stages of instance startup to a usable state where normal users may access it.
Oracle General 
