Difference between primary key and unique key ?
- 77 Answers
- 191040 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
What are the different windows events activated at runtime ?
How to handle a single quote in oracle sql?
How to calculate date and time differences in oracle?
Explain the difference between sql and oracle?
How to view existing locks on the database?
Explain what are the different type of segments?
Explain the use of file option in exp command.
How can we find out the current date and time in oracle?
How to connect to oracle using service name instead of sid?
Explain about achiever in sql?
What is a synonym? What are its various types?
What is background process in Oracle?
How to define an anonymous block?
what are the advantages of running a database in archive log mode?
Is a rollback possible to any savepoint?
