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 are the joins,primary key,foriegn key, candidate key,
super key and expain them?

Answer Posted / karthik

Join is a keyword which is used to join two or more table.

The unique column in a table is called primary key.

If primary key acting as a normal attribute in some other
table then this attribute is called foreign key.

If table is having more than one unique attribute then the
rest of the attributes of primary key is called candidate key.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many cores do I need for sql server 2016?

875


How to define and use table alias names in ms sql server?

1104


What area unit the various kinds of info compression introduced in sql server 2008?

1066


Give me any three differences between Truncate and Delete.

1083


Explain alternate key, candidate key and composite key in sql server?

895


What is the difference in accessing db between sql server vs sql azure?

174


Detail about query optimizer?

1079


What is the use of tempdb? What values does it hold?

1050


How to find the source of a table in sql server?

977


What is tempdb in sql server?

950


What is the difference between push and pull subscription? : sql server replication

1196


As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1111


What are scalar functions?

982


What are sub reports?

201


Is it possible to update the views? If yes, how, if not, why?

1007