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 candidate key, alternate key, composite key.

Answer Posted / swapna

A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.

A key formed by combining at least two or more columns is
called composite key.

Is This Answer Correct ?    348 Yes 54 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is merge join?

1194


When I run the sql server 2000 setup, it just hangs. What do I do?

1082


How to identify current user in ssrs report?

401


List the data types available in mssql?

1031


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1061


What is cursors? And what are the different types of cursor?

1144


Some queries related to SQL

980


What is full outer join in sql server joins?

1068


What does nvl stand for?

940


What are different types of views?

946


Explain what are page splits? : SQL Server Architecture

1059


How to drop an existing user defined function in ms sql server?

1023


What do you understand by hotfixes and patches in sql server?

987


What is the difference between the 2 operating modes of database mirroring?

1107


What is the current pricing model of SQL Azure?

104