Difference between primary key and unique key ?
Answer Posted / susil kumar rout
When we applied primary key constraint upon a column of a table internally oracle create a cluster index.In case of unique constraint,oracle create a non-cluster index.
In a table or entity one primary key and one or more than one
unique key can be applied.
We can't insert duplicate value or null value to primary key
column where as null value can insert into unique key column.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert dates to characters in oracle?
What is the use of aggregate functions in oracle?
What is instant client oracle?
What are the types of trigger in oracle?
What is hash cluster in oracle?
What is varray?
Can the query output be sorted by multiple columns in oracle?
What is rich query?
How many types of database triggers exist?
How to run create database statement again?
State and explain the different types of data models?
What is oracle thin client?
can u plz provide me oca sql dumps please i need them
Can a formula column referred to columns in higher group ?
Explain what are the different type of segments?