Difference between primary key and unique key ?
- 77 Answers
- 199057 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 / pramod paunikar
Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a non-clustered index by default. Another
major difference is that, primary key does not allow NULLs,
but unique key allows only one NULL only.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to define an anonymous procedure without variables?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Write a syntax for update query in oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How to install oracle database 10g xe?
How to use "out" parameter properly?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is where clause in oracle?
What is merge statement used for?
How to speed up webrick?
What happens to the current transaction if the session is killed?
What is different types of joins?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is the difference between pre-select and pre-query?
How many memory layers are in the oracle shared pool?
