Difference between primary key and unique key ?
- 77 Answers
- 190659 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 / sunil upadhyay
the basic difference is that primary key can not have null
value whereas Unique key can have null values.two null
value are not same.One table may have more than one Unique
Key Constraint
columns, but should have only one Primary Key Constraint
column.
| Is This Answer Correct ? | 88 Yes | 51 No |
Post New Answer View All Answers
What is program global area (pga) in oracle?
Describe the types of sub query?
How to delete a column in an existing table in oracle?
Difference between inner join vs where ?
Differentiate between post-database commit and post-form commit?
What is enter substitution variable in oracle?
How to use subqueries in the from clause in oracle?
How to recover a dropped table in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is the difference between a hot backup and a cold backup in oracle?
What is system tablespace?
How to find the duplicate rows count from employees table in oracle?
What is Virtual Private Database in Oracle?
What are dml statements in oracle?
How will you differentiate between varchar & varchar2?
