Difference between primary key and unique key ?
- 77 Answers
- 190727 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 to filter out duplications in the returning rows using oracle?
How many types of cluster table in Oracle?
What is a subquery in oracle?
Explain self joins in oracle?
Which is better Oracle or MS SQL? Why?
Explain drop constraint oracle?
What is oracle open database communication (odbc)?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is a nvl function? How can it be used?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to revoke create session privilege from a user in oracle?
What is null value in oracle?
How to create a stored procedure in oracle?
How will you identify oracle database software release?
How to call a stored function with parameters?
