Difference between primary key and unique key ?
- 77 Answers
- 190702 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 / mohammad ali
-The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values.
-We can declare only one primary key in a table
but a table can have multiple unique key
-Clustered index is created on Primary key constraint and
non clustered unique indexes is created on Unique key constraint.
-Primary key columns automatically become NOT NULL (unique
keys can contain nulls).
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
master table and child table performances and comparisons in Oracle ?
How do you store pictures in a database?
query optmization techniques and quwry analyser+projects+ppts
Can I create users through internet explorer in oracle 10g?
What are advantages of dateset in datastage?
How do I recompile a procedure in oracle?
Explain parameter file in oracle.
What is an external table?
How to create id with auto_increment on oracle?
What privilege is needed for a user to create views in oracle?
How to invoke the data pump export utility?
What is the Tune Query
What is oracle rownum?
Where are the settings stored for each instance in oracle?
How to rebuild an index in oracle?
