Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 209930 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 can you use check constraints for self referential integrity?
What is the sql query to concatenate column values from multiple rows in oracle?
What is meant by joins?
What suggestions do you have to reduce the network traffic?
What is an oracle wallet?
What are set operators?
What are the tools for Oracle ?
How to initialize variables with default values?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to retrieve values from data fields in record variables?
What do you understand by a database object?
How remove data files before opening a database?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Why use resource manager in Oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
