Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210670 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
How many data types are supported?
Is there a function to split a string in plsql?
How can we find out the current date and time in oracle?
What do you mean by a deadlock?
Explain the use of owner option in exp command.
How to filter out duplications in the returning rows using oracle?
How to delete a user account in oracle?
Explain enable novalidate constraint.
Give the different types of rollback segments.
What is the difference between a user and a schema in oracle?
How to assign data of the deleted row to variables?
What is raw datatype in oracle?
Explain compound trigger in oracle?
How to calculate date and time differences in oracle?
Will you be able to store pictures in the database?
