Difference between primary key and unique key ?
- 77 Answers
- 190504 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
Explain the use of rows option in imp command.
What is a snapshot log?
Is oracle a programming language?
What is the difference between primary key and unique key and foreign key in oracle?
What is bulk copy or bcp in oracle?
What do you mean by cdb and pdb in oracle 12c?
How to define an explicit cursor in oracle?
How to see free space of each tablespace?
State all possible different index configurations a table can possibly have?
What is merge in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How can windows applications connect to oracle servers?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Explain the difference between replace() and translate() functions in oracle?
What is oracle update statement with inner join ?
