Difference between primary key and unique key ?
- 77 Answers
- 198053 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 / kundn
Unique key Primary key
1. Can have null value 1. Can not have null value
2.Table can have multiple 2. Table Can have multiple unique
Unique keys keys
3Single column at a time 3. May be combination of one or
or more columns
| Is This Answer Correct ? | 14 Yes | 17 No |
Post New Answer View All Answers
Is truncate autocommit in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to compare dates in oracle sql?
What is a initialization parameter file in oracle?
How to concatenate two text values in oracle?
How do I manually uninstall oracle client?
What are a query and state the different types of queries and their uses?
How can we find out the duplicate values in an oracle table?
What is a static data dictionary in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to get execution statistics reports on query statements?
How to update values in a table in oracle?
 What are the oracle DML commands possible through an update strategy?
what is normalisation?what are its uses?
Please explain drop constraint oracle?
