What is differance unique key and primary key.

Answer Posted / hema

Unique :: it does not allow duplicate values but allows
null values.
Primary:: Primary does not allow duplicate values as wel as
it dosnt allow null values.

unique+not null==Primary key...

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you break a loop in pl sql?

735


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

948


How can a pl sql block be executed?

684


What does trigger mean in slang?

738


In pl/sql, what is bulk binding, and when/how would it help performance?

741


what are date and time functions in mysql? : Sql dba

723


What is difference between sql and excel?

701


What are different joins used in sql?

738


What is the command used to fetch the first 5 characters of a string?

932


Does access use sql?

750


Define implicit and explicit cursors.

814


What is sql and db2?

729


What is auto increment feature in sql?

821


what is clause? : Sql dba

763


What is difference between procedure and trigger?

673