Concepts and Architecture Question:
Tell me what is difference between UNIQUE constraint and PRIMARY KEY constraint?
Answer:
A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls.Unique key cannot be used to create referential integrity whereas primary key can do.
| Previous Question | Next Question |
| Tell me what are the uses of Rollback Segment? | Explain what are the Limitations of a CHECK Constraint? |