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...

Difference between primary key and unique key ?

Answer Posted / sikander

Primary key does not allow null value but unique key allows
null value. suppose tableA two column : columnB & columnC .
where coulmnB is primary key & columnC is unique key.
If we insert null value in columnB.It will not accept
columnB but columnC

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete a column in an existing table?

1018


How to estimate disk space needed for an export job?

990


What is materialized view in Oracle?

1042


How to use like conditions in oracle?

994


What is the parameter mode that can be passed to a procedure?

979


What is the usage of merge statement?

1095


How to load a large xml file?

1002


What is control file used for?

1098


What is the data pump export utility?

1021


What is set verify off in oracle?

1030


What operating systems are supported by oracle database 10g xe?

983


Explain self joins in oracle?

949


How to apply filtering criteria at group level in oracle?

986


What types of joins are used in writing subqueries?

937


What is a tns file?

938