Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210276 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 / ankit kumar singh
Primary Key:
* Primary Key can not contain null value
* Clustured index is created in Primary key.
* Primary Key allows Each row in a table to uniquely
identified and insures that no applicable row exists.
Unique Key:
* Unique Key can contain null value.
* More than one Unique key in a table can be declared.
* Non-clustered index is created in unique key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain view?
How to store only time; not date and time?
What do you mean by merge in oracle and how can you merge two tables?
How can we view last record added to a table?
What are the oracle differences between nvl and coalesce
What are the arithmetic operations?
What are the uses of linked server and explain it in detail?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is data file?
How to build data dictionary view an new database?
What is a dead lock in oracle?
Explain implicit cursor.
What are nested tables?
Can we use bind variables in oracle stored procedure?
What do you mean by group by clause?
