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

Is sql a microsoft product?

498


Explain how to use transactions efficiently : transact sql

529


how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

512


What are the operators in sql?

529


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

549






What is equi join in sql?

610


What is rownum in sql?

559


What are all the common sql functions?

565


What do you think about pl/sql?

535


How can a function retun more than one value in oracle with proper example?

586


what are the differences between require and include, include_once and require_once? : Sql dba

530


What is sql character function?

543


explain the delete statements in sql

583


What is use of term?

625


How do I add a database to sql?

582