Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212299 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 / prashant t.
First difference is that primary key doesn't accept null
values whereas unique accepts one or multiple.
second difference is that Clustered index is created on
Primary key constraint and non clustered unique indexes is
created on Unique key constraint.
| Is This Answer Correct ? | 320 Yes | 94 No |
Post New Answer View All Answers
What is procedure overloading in oracle?
What happens in oracle commit?
Please explain oracle left join with an example?
How to write a query with a right outer join in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
Can you have more than one content canvas view attached with a window ?
What is oracle and what are its different editions?
What is an index associated with a constraint?
How to upsert (update or insert into a table)?
Can sub procedure/function be called recursively?
What is a cursor in oracle?
Can a parameter be passed to a cursor?
How many types of tables are there in oracle?
Is rowid unique in oracle?
How to experiment a data lock in oracle?
