Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212359 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 / deen dayal sharma
1. PRIMARY KEY & UNIQUE KEY both uniquely identity of each
row in a table.
2. BOTH keys will not contain repeated value.
3. One table may have more than one Unique Key Constraint But
it should have only one Primary Key Constraint column.
4. BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the data type of dual table?
What are the limitations of check constraint?
What is the difference between a user and a schema in oracle?
how to clone 9i Database on to 10g Database.
Explain oracle 12c new features for developers?
Hi Can any one tell me what are the API's used in requisition import.
How to resolve the ORA-39133 error in Oracle?
what is the use of system.effective.date variable in oracle?
What are set operators?
How to use subqueries with the in operator using oracle?
Is postgres faster than oracle?
Explain the dml?
What do you mean by cdb and pdb in oracle 12c?
How to login to the server without an instance?
How to define an anonymous procedure with variables?
