Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210344 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
How to unlock the sample user account in oracle?
How to start your 10g xe server from command line?
Give the advantages and disadvantages of clusters.
What is the difference between a hot backup and a cold backup in oracle?
How index is implemented in oracle database?
What are the uses of synonyms?
How to insert a record into a table?
Explain a synonym?
What is the difference between 10g OEM and 11g OEM?
Explain the difference between sap and oracle?
How do I call oracle stored procedures that take no parameters?
In what script is snap$ created? In what script is the scott/tiger schema created?
What are ddl statements in oracle?
How to compare dates in oracle sql?
What is a data dictionary and how can it be created?
