Difference between primary key and unique key ?
- 77 Answers
- 198776 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 / ibrahim
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
PRIMARY KEY not accepts null values but unique can accept null.
but the core different between primary key and unique is we use primary key to link tow tables with each other but we can not use unique key to do this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What happens if you lost a data file?
Explain how are indexes update?
How to create a temporary table in oracle?
What is the difference between a primary key & a unique key?
Explain the use of record length option in exp command.
How to display row numbers with the records?
What are the uses of synonyms?
What is oracle latest version?
How data locks are respected in oracle?
How to set a transaction to be read only in oracle?
What is oracle open database communication (odbc)?
What is a data dictionary and how can it be created?
What is raw datatype?
What do you mean by a deadlock?
What is merge in oracle?
