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 / vitthal parkar

Unique key Primary key
1. Can have null value 1. Can not have null value
2.Table can have multiple 2. Table Can have multiple unique
Unique keys keys
3Single column at a time 3. May be combination of one or
or more columns

Is This Answer Correct ?    35 Yes 58 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a sub query? What are its various types?

1078


Explain the dml?

919


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1948


What are the ways tablespaces can be managed and how do they differ?

2270


What is procedure overloading in oracle?

992


How to get a list of all background sessions in the database?

943


What is execute immediate in oracle?

949


What is a initialization parameter file in oracle?

987


How to view the data files in the current database?

1042


How many types of cluster table in Oracle?

985


How to view all columns in an existing table?

873


Point out the difference between user tables and data dictionary?

931


What are the differences between char and varchar2 in oracle?

1072


What is integrity and what is constraint??Explain with example

2213


what is the dual table in oracle?

932