Difference between primary key and unique key ?
Answer Posted / himanshu porwal
Primary key does not allow null values whereas in UNIQUE constraint we can have 1 null value means for that column one null value is allowed.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the difference between Delete, Truncate and Drop in Oracle?
How to insert a new row into a table in oracle?
Explain the truncate in oracle?
What is a system tablespace and when it is created?
What is a user role in oracle?
How can we force the database to use the user specified rollback segment?
How to create an initialization parameter file?
What happens if recursive calls get out of control?
Can we write dml statement in function in oracle?
Explain the use of indexes option in exp command.
What do you mean by merge in oracle and how can we merge two tables?
What is Virtual Private Database in Oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
What is procedure overloading in oracle?
Explain rename?