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 Primary key and
unique index?

Answer Posted / guest1

Using the Primary Key you can establish referential
integrity. Unix index will be created upon the Primary Key
column, and the data will be seperately placed in the Index
space. If you have not created Unix Index, while accessing
the table it leads to SQLCODE = -540

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we insert update delete in view?

972


How to find the number of rows in db2 tables?

1073


What is null value in db2?

1026


What is the maximum size of varchar data type in db2?

1137


What is cobol db2?

1003


What is db2 command?

1040


Which isolation level provides maximum concurrency?

1153


What is explain plan in db2?

999


Explain the function of data manager.

1046


Why do chiropractors use drop table?

1110


What action db2 takes when a program aborts in the middle of a transaction?

1156


How to fetch the last row from the table in SQL (db2)?

1657


What is reorg?

1162


What is difference between rollback and commit?

1164


What is the picture clause of null indicator variable?

1138