Difference between primary key and unique key ?
Answer Posted / ark chowdary
7. Primary Key doesnt allow the Null Values. where as in
Unique accept the Null values.
One table may have more than one Unique Key Constraint.
But it sholud have only one Primary Key Constraint column.
| Is This Answer Correct ? | 77 Yes | 47 No |
Post New Answer View All Answers
What is transaction control statement and how many types of transaction control statement in Oracle?
Who developed oracle & when?
How to invoke the data pump import utility?
What is the difference between Delete, Truncate and Drop in Oracle?
How to count duplicated values in a column in oracle?
What are the major difference between truncate and delete?
How to return top 5 rows in oracle?
How to load excel data sheet to oracle database
20. Using a set operator, display the client number of all clients who have never placed an order.
What is ADDM Advisor in Oracle?
Explain the use of online redo log files in oracle.
Explain cascading triggers.
What is analyze command used for?
How to convert times to characters in oracle?
Does oracle database need java?