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 is the use of file param in imp command?
What is a trace file and how is it created in oracle?
What is the oracle implicit cursor?
Explain alias?
What is the difference between substr and instr?
When do I need to use a semicolon vs a slash in oracle sql?
How to use values from other tables in update statements using oracle?
How to load data from external tables to regular tables?
What is the difference between sharding and partitioning?
How to define an anonymous procedure without variables?
How do I call oracle stored procedures that take no parameters?
What is the string concatenation operator in oracle?
What is the Tune Query
Which is better Oracle or MS SQL? Why?
what is a Nested Loop join?