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 candidate key & primary key,different b/t the two?

Answer Posted / naz

A Candidate Key can be any column or a combination of
columns that can qualify as unique key in database. There
can be multiple Candidate Keys in one table. Each Candidate
Key can qualify as Primary Key.

A primary key is the column that uniquely identifies a
record. A primary key should be UNIQUE and never be NULL.

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to select a random record from a table?

889


What is the meaning of flat file database?

940


How many rows can a database hold?

959


What is normalization and why it is used?

1057


Explain openquery function and openrowset function?

888


Where is database used?

862


What is dba stand for?

894


What is data modelling techniques?

792


Can you have more than one cursor open at any one time in a program ?

887


Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

964


Give us a non-computer example of preemptive and non-preemptive scheduling?

863


Explain meant by 3-tier architecture?

884


Is database a data structure?

811


What is the best way to determine whether firebird server is running?

1007


What are cursors and what are the situations you will use them?

921