Difference between primary key and unique key ?
Answer Posted / deen dayal sharma
1. PRIMARY KEY & UNIQUE KEY both uniquely identity of each
row in a table.
2. BOTH keys will not contain repeated value.
3. One table may have more than one Unique Key Constraint But
it should have only one Primary Key Constraint column.
4. BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create an oracle testing table?
Where is the export dump file located?
Difference between hot backup vs. Cold backup?
How to omit columns with default values in insert statement in oracle?
What is truncate oracle?
What are the differences between primary key and unique key?
How to assign data of the deleted row to variables?
What is bulk copy or bcp in oracle?
How to convert times to characters in oracle?
How are extents allocated to a segment?
How to rename a tablespace in oracle?
How to insert a new row into a table in oracle?
Can we protect our pl/sql source code?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is SQL Tuning Advisor in Oracle?