Difference between primary key and unique key ?
- 77 Answers
- 198023 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 / ark chowdary
7. Primary Key doesnt allow the Null Values. where as in
Unique accept the Null values.
One table may have more than one Unique Key Constraint.
But it sholud have only one Primary Key Constraint column.
| Is This Answer Correct ? | 77 Yes | 47 No |
Post New Answer View All Answers
What is a dead lock in oracle?
Explain oracle left join with an example?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Explain oracle data types with examples?
How to specify default values in insert statement using oracle?
How to define an anonymous procedure with variables?
How to unlock the sample user account in oracle?
What is the disadvantage of User defind function?
Can you tell me how to add new column in existing views?how?How is possible?
What do you understand by a database object? Can you list a few of them?
Is there a combination of "like" and "in" in sql?
How to view existing locks on the database?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to drop a tablespace?
Is postgres faster than oracle?
