Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 user defined functions? : Sql dba

1022


What are the ways on commenting in a pl/sql code?

1124


Is it possible to create the following trigger: before or after update trigger for each row?

1280


What are the two different parts of the pl/sql packages?

1077


How does stored procedure reduce network traffic?

1003


What is an exception in pl/sql?

1075


What is the difference between a query and a report?

962


Is sql developer case sensitive?

992


What are pl/sql cursors?

1045


How do I quit sql?

947


What is the clause we need to add in function body to return variable?

1009


What is sql data?

984


What is the difference between sum and count in sql?

984


Is crud a cuss word?

1028


What is anonymous block in sql?

1116