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 tns name?
How does oracle handle read consistency?
Explain integrity constraint?
How to calculate date and time differences in oracle?
How to write a query with a left outer join in oracle?
State all possible different index configurations a table can possibly have?
Explain compound trigger in oracle?
What is a trigger oracle?
What is recycle bin in Oracle?
How to define and use table alias names in oracle?
How to see the table columns used in an index?
What are joins, explain all types of joins?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is meant by raw datatype?
What happens to the current transaction if a ddl statement is executed?