Interested to Buy Any Domain ? << Click Here >> for more details...
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?
- 4 Answers
- 10054 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 |
When creating a user, what permissions must you grant to allow them to connect to the database?
How client makes connection with server in client/server architecture?
how can it possibble to see the report output in excel sheet in oracle applications
Name two files used for network connection to a database.
When the procedures or packagess become invalidate
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
Give the stages of instance startup to a usable state where normal users may access it.
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
What are the mandatory setups in setting up a PO in oracle
What is database schema?
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
Explain the difference between a hot backup and a cold backup and the benefits associated with each
Oracle General 
