Difference between primary key and unique key ?
Answer Posted / jason james john
unique key is a key that uniquely defines the characteristics of each row whereas primary key consists of characteristics that cannot collectively be duplicated by any other row.primary key will not allow null values whereas unique key will allow nulls.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why should I use oracle database?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is the use of file param in imp command?
What is the parameter mode that can be passed to a procedure?
How to sort output in descending order in oracle?
How can I create database in oracle?
Explain oracle data types with examples?
Can sub procedure/function be called recursively?
How to get last row id?
various types of hints and their usage
Explain integrity constraints?
How to retrieve data from an cursor to a record?
 How to use an oracle sequence generator in a mapping?
what is normalisation?what are its uses?
What is a sub query? What are its various types?