Difference between primary key and unique key ?
- 77 Answers
- 190733 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 / chandra bhan kumhar
1. Primary key accepts a value only single time not more then one time means it doesn't allow repetition same as for unique key.
2. Primary key don't allow null values ,but unique key allow null values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Can sub procedure/function be called recursively?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What are set operators?
What is null value in oracle?
How to add another datafile to a tablespace?
What is the difference between formal parameters and actual parameters?
What are the restrictions on external table columns?
What is an Oracle Instance?
What is using clause and give example?
What are the major difference between truncate and delete?
How do I spool in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Explain mutating triggers.
How to create an oracle testing table?
