what is the different between unique+not null & primary key,

Answer Posted / giri

unique:it does not allow duplicate values but it allow null values.
not null:It does not allow null values but allow duplicate values.
primary:It does not allow both duplicate and null values.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger and stored procedure in sql?

809


Does sql use python?

801


What is recursive join in sql?

799


What is a unique constraint?

850


Explain constraints in sql?

809


What is the difference between microsoft sql and mysql?

756


Why primary key is required?

754


What is a temp table?

774


What is embedded sql what are its advantages?

730


How to use sql*plus built-in timers?

810


How do I run sql?

864


What is sqlcontext?

752


What is rename in sql?

762


How to prepare for oracle pl sql certification?

832


What is the file extension for sql database?

713