Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207498 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
What is the data pump export utility?
What is the best way to do multi-row insert in oracle?
What is Segment Advisor in Oracle?
What is the difference between sharding and partitioning?
Explain the importance of .pll extension in oracle?
material view and view disadvantages?
Explain the use of online redo log files in oracle.
How to define a variable to match a table column data type?
What does sharding mean?
What is query image?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is memory advisor in Oracle?
How to load a large xml file?
How can we force the database to use the user specified rollback segment?
How to load data through external tables?
