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 difference between unique and primary key

Answer Posted / divyarao

primary key accepts only values which has no duplication ,and does not accept null values . for a a table there should be only one primary key constraint.
whereas in unique key ,it accepts null values .here also there should not be any duplication ,a table may have more than one unique key constarint

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 the difference between filters and conditions?

2500


What is database definition (dbd)?

1032


What information can be stored in a database?

1152


Define denormalization.

1245


Define database.

1049


What are the two major subsystems of system r?

1150


Explain the terms database and dbms. Also, mention the different types of dbms.

958


Give us a non-computer example of preemptive and non-preemptive scheduling?

971


Explain 2nf?

1005


What is tuple with example?

1003


What is meant by database management system?

1191


What is a string in database?

1004


What is a foreign key constraint?

1080


If I use netlib, will I find many other users to network with?

943


What are the four objectives of the selection of a data type?

959