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

define primary key & secondary key?

Answer Posted / manoj

primary key is a key which always accept unique value.

secondary key is a key which when you are making primary key
for more than one column as primary key for retrieving of
reords.
eg.
create table tnam
(ano number,
bno number,
bname char(12),
primary key(ano,bno))

In this bno is secondary key.

Is This Answer Correct ?    31 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql sequential or random?

980


What are sql data types?

947


What does seeding a database mean?

889


how to shutdown mysql server? : Sql dba

1027


What is the use of count (*) in sql?

977


How do I create a sql database?

947


how to check myisam tables for errors? : Sql dba

1256


How do I find sql profiler?

884


What is primary key in db?

933


What does the sign mean in sql?

917


What are sql functions? Describe in brief different types of sql functions?

1009


How do you declare a variable in pl sql?

964


How do we accept inputs from user during runtime?

989


What is dml statement?

899


Show the two pl/sql cursor exceptions.

1103