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

How to find out what oracle odbc drivers are installed?

827


How to turn on or off recycle bin for the instance?

848


What is a proxy class?

767


How do I reset a sequence in oracle?

859


What is literal?

781


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1695


Is it possible to insert comments into sql statements return in the data model editor ?

2348


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1721


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1766


How to speed up webrick?

854


What privilege is needed for a user to create tables in oracle?

765


What is the difference between post-database commit and post-form commit?

819


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1829


Compare and contrast between sql and sql server and explain its various functions?

760


What is not equal to in oracle?

778