Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212266 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / dinesh
Primary Key:
It wont accept NULL values.
It wont accept Duplication.
Unique Key:
It accepts NULL values.
Foreign Key:
It accepts NULL values.
It accepts Duplication.
Main point is, A Foreign key denotes a Primary key in the another table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is there a function to split a string in plsql?
When do you get a .pll extension in oracle?
How to set up autotrace for a user account?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Can we write dml statement in function in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to view all columns in an existing table?
How to add a new column to an existing table in oracle?
What is translate in oracle?
What are dml statements in oracle?
what is port in oracle? how is it related to database application.
Is oracle an open source?
How to use "for" statements in oracle?
What is an oracle user role?
What do you mean by cdb and pdb in oracle 12c?
