Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210066 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 / chintan desai
Primary key don't have any null value, each table have only
one primary key. Not support duplicate value.
Unique key is uniquely identify, more then one unique key
allow in table.
Here the main different is what primary key do not have any
null value where unique key have only one null value.
Ex: here t1 is the name of table which have two field id and
name. here id is identify as a unique key then unique key's
null value look like under bellow:
1 chintan
NULL komal
2 ck
NULL NULL
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How to use "in out" parameter properly?
What is key preserved table?
How to create id with auto_increment on oracle?
What is oracle instant client?
Explain overloading. Can functions be overloaded?
what is a Nested Loop join?
What is a snapshot log?
why dont we assign not null constraint as table level constraint.
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is a sub query? Describe its types?
Explain joins in oracle?
How data locks are respected in oracle?
Is oracle an open source?
What do you mean by redo log file mirroring?
