Primary key's main role is to make field as unique and relates to ot

Difference between primary key and unique key ?

Question Posted / vijay

Answer Posted / vijay

Primary key's main role is to make field as unique and
relates to other sub table. Whereas unique is role only to
keep unique value in that field.

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What do you mean by group by clause?

977

What is data type in oracle?

1037

How to speed up webrick?

1004

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1008

what is the difference between substr and instr function in oracle?

1033

What is parameterized cursor in oracle?

1063

How to manage transaction isolation level?

948

Explain what are clusters?

1041

What happens to the indexes if a table is recovered?

939

Why do we need integrity constraints in a database?

967

What is a proxy object?

1005

How to put more than 1000 values into an oracle in clause?

969

Is a rollback possible to any savepoint?

997

What do you mean by merge in oracle and how can we merge two tables?

1000

What happens to the current transaction if the session is killed?

924