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
Explain implicit cursor.
Can you drop an index associated with a unique or primary key constraint?
How to create a single index for multiple columns?
What is difference between cartesian join and cross join?
Which is better Oracle or MS SQL? Why?
Explain coalesce function?
How to update values on multiple rows in oracle?
What is merge in oracle?
Which is faster join or subquery in oracle?
How to view the data files in the current database?
What do you mean by a tablespace?
What are a query and state the different types of queries and their uses?
What is a static data dictionary in oracle?
What is hot backup and logical backup?
What is coalesce function?