Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 208509 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 / ela tiku
1. Primary key does not allow Nill value whereas Unique key
allows Null values.
2. There can more than one Unique key for a table however
there is only one primary key for ant tanle.
2. Whenever a primary key is assigned by default a
Clustered Index is created whereas When a Unique key is
created a Non Index clustered index is created...
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
How to turn on or off recycle bin for the session?
What is the difference between postgresql and oracle?
What is a procedure in oracle?
What is a tns file?
How to create a server parameter file?
How many types of database triggers exist?
How to convert characters to dates in oracle?
what are the advantages of running a database in archive log mode?
What is the exact use of Collections?
What is a table index?
what is reindexing?
What is oracle server autotrace in oracle?
How do I learn what codesets are available in oracle?
How to commit the current transaction in oracle?
How to delete multiple rows from a table in oracle?
