What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?

Answer Posted / kiran

if unique then it can have null

but if column has primary then it cannot have null values
and duplicate values

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Reduced List of Values?

1706


What is archive log in Oracle?

599


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

1964


What is the recommended interval at which to run statspack snapshots, and why?

2435


Can multiple columns be used in group by in oracle?

548






What is an oracle cursor variable?

609


How do I reset a sequence in oracle?

596


How to set up autotrace for a user account?

596


what is IDE,DMV in sql server?

2248


What are the logical operations?

677


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1590


How to define an anonymous procedure without variables?

551


What are the common oracle dba tasks?

625


Explain index?

747


master table and child table performances and comparisons in Oracle ?

1666