Difference between primary key and unique key ?
- 77 Answers
- 199164 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
How to create a new table by selecting rows from another table?
Explain the use of inctype option in exp command.
What is an oracle transaction?
What are the different types of synonyms?
Is oracle a relational database?
Explain the use of indexes option in exp command.
How can you merge two tables in oracle?
Why oracle is used?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Explain how are indexes update?
Explain an exception?
Can multiple cursors being opened at the same time?
How to use existing values in update statements using oracle?
What is the relationship among database, tablespace and data file?
How to insert multiple rows with one insert statement in oracle?
