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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

can you any body tell me the difference between candidate
key and primary key

Question Posted / hari

Answers were Sorted based on User's Feedback



can you any body tell me the difference between candidate key and primary key..

Answer / vani

A candidate is a one that can identify each row in a table
uniquely.If a table has more than one candidate key , one
of them will become primary key.
The potential primary key is a candidate key.

Is This Answer Correct ?    6 Yes 0 No

can you any body tell me the difference between candidate key and primary key..

Answer / arijit

A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data. Each table may have one or more candidate
keys. One of these candidate keys is selected as the table
primary key.

Is This Answer Correct ?    2 Yes 1 No

can you any body tell me the difference between candidate key and primary key..

Answer / prasad

There can be more than one index in a table.
But only one field can be a Primary Key in a table.
All other index fields in a table are called candidate keys.

Is This Answer Correct ?    2 Yes 1 No

can you any body tell me the difference between candidate key and primary key..

Answer / pooja

A primary key is one that uniquely identiifes each row.
and there is only one primary key per table.

candidate key:All that fields which can be selected as
primary key are called candidate keys.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is indexing?

0 Answers   AOL,

What are the advantages of paper records?

0 Answers  

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

What is trace flag in sql server?

0 Answers  

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

What is a sub-query? When would you use one?

3 Answers  

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

What is a view? is View updatable?

17 Answers   IBM, L&T,

Detail about the hardware which is supported by SQL server?

0 Answers  

What is factless fact table? : sql server analysis services, ssas

0 Answers  

What is the difference between ddl and dml?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories