Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210095 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 / vaithianathan
primary key not accepts null value and
not allows duplicate values.
but Unique key not allows duplicate values
but it accepts ONLY ONE NULL VALUE.
only one primary key allowed per table
we can create multiple unique keys
on the table
By Default, Primary key creates Clustered Index and Unique key Creates Non Clustered Index
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which is better Oracle or MS SQL? Why?
When system tablespace is created?
State all possible different index configurations a table can possibly have?
How to write date and time literals in oracle?
What is sequence?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to create a new table by selecting rows from another table?
Which is faster join or subquery in oracle?
What is raw datatype in oracle?
Explain the importance of .pll extension in oracle?
List out the components of logical database structure of oracle database.
What is a named program unit?
How much memory your 10g xe server is using?
What happens to the indexes if a table is recovered?
Name the three major set of files on disk that compose a database in Oracle?
