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 / umapathy.r

The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values assume that t3 is a table with two
columns t1 having primary key constraint and t2 having
unique constraint if u try to insert null into t2 it will
accept that values whereas column t1 will not accept null

Is This Answer Correct ?    1164 Yes 121 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of consistent option in exp command.

1132


Explain the use of record option in exp command.

1065


What are the differences between lov and list item?

1139


What is open database communication (odbc) in oracle?

1048


How to write text literals in oracle?

1118


List the various oracle database objects?

1108


How to define a cusotmer as a supplier in ORACLE R12

2301


How to execute a stored program unit?

1126


How to speed up webrick?

1121


How to revoke create session privilege from a user in oracle?

1068


Why does oracle 9i treat an empty string as null?

1125


how to handle exceptions in post production

1482


How to create a single index for multiple columns?

1079


What happens in oracle commit?

1077


Describe the types of sub query?

1056