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

What is nvl?

597


What is tuple in sql?

531


What is sql in oracle?

608


what are all different types of collation sensitivity? : Sql dba

512


What is thread join () in threading?

528






What is difference between joins and union?

517


What is sql resultset?

517


What is fmtonly in sql?

517


Can function return multiple values in sql?

514


What are the main features of cursor?

615


What is the use of double ampersand (&&) in sql queries? Give an example

594


Can we use ddl statements in stored procedure?

687


Why commit is not used in triggers?

567


Which are the different character-manipulation functions in sql?

536


What is delete command in sql?

541