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 |
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
Is it possible to drop a column in a table which contains only one column? How?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
For web applications from which version of Oracle is suitable?
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.
Give the reasoning behind using an index.
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What is an Oracle database Full Backup?
hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent
What is index? How many types of indexes?
Give two examples of how you might determine the structure of the table DEPT.
what are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,