Difference between primary key and unique key ?
Answer Posted / nithin
1. There can be more than one unique key in a row or table
but there can be only one primary key in a row or table.
2. Primary key does not accept NULL values but Unique key
accepts even NULL values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences between interval year to month and interval day to second?
How to specify default values in insert statement using oracle?
Explain temporal data types in oracle
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Explain oracle’s system global area (sga).
What is concurrency in oracle?
What is Reduced List of Values?
Explain compound trigger in oracle?
How to define an anonymous procedure with variables?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What do you mean by a deadlock?
How to export data to a csv file?
What is set operator oracle?
How will you identify oracle database software release?