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

Why plvtab is considered as the easiest way to access the pl/sql table?

1208


Is mariadb nosql?

1039


What is a database event trigger?

1156


What do you mean by “trigger” in sql?

1069


What are some emotional triggers?

979


How do you run a query?

989


What are inner and outer joins examples of both?

951


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1093


What view means?

975


what are the authentication modes in sql server? How can it be changed? : Sql dba

1419


How is data stored on a disk?

1019


Which is faster subquery or join?

1210


Explain autonomous transaction.

1152


How can you load multi line records? : aql loader

1071


What is the difference between instead of trigger and after trigger?

1006