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

Can we change the table name in sql?

944


What is cursor status?

1191


What is scalar function in sql?

1045


Does truncate table reset auto increment?

999


what is top in tsql? : Transact sql

1124


How can use stored procedures in sql?

1142


How show all rows in sql?

1016


What is coalesce sql?

1004


What is a data manipulation language?

1026


What is java sql connection?

1063


How would you pass hints to the sql processor?

983


What is posting?

1041


Why do we use set serveroutput on?

969


What is multiple partition?

972


How to connect a sql*plus session to an oracle server?

1130