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 |
can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
what are the tools used for oracle 10g in real time.
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
key flexfield structure
What view would you use to determine free space in a tablespace?
how can it possibble to see the report output in excel sheet in oracle applications
Give two methods you could use to determine what DDL changes have been made.
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
Where in the Oracle directory tree structure are audit traces placed?
What are the mandatory setups in setting up a PO in oracle