Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210273 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 / deen dayal sharma
1. PRIMARY KEY & UNIQUE KEY both uniquely identity of each
row in a table.
2. BOTH keys will not contain repeated value.
3. One table may have more than one Unique Key Constraint But
it should have only one Primary Key Constraint column.
4. BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to handle exceptions in post production
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Explain the use of ignore option in imp command.
What is a tns service name?
What is a oracle database?
Explain what are clusters?
How to define an anonymous procedure without variables?
What privilege is needed for a user to create views in oracle?
What do you understand by a database object? Can you list a few of them?
What are the various types of snapshots ?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is a lookup table in oracle?
Why do we use coalesce function in oracle?
