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

Can we take the full database backup in log shipping?

999


Can the “if update (colname)” statement be used in a delete trigger?

1037


What does executeupdate return?

1036


What is the beast way to write CTE in SQL Server ?

1100


How to create dbo table in sql server?

1009


what are the reporting service components in SSRS?

172


Tell me what is a linked server?

1095


Explain why variables called the most powerful component of ssis?

1178


What are various aggregate functions that are available?

1048


How to create a user name in a database?

1105


What is difference between foreign key and unique key?

1052


What are the advantages of partitioning?

1184


What are the steps you can take to avoid “deadlocks”?

1026


What do you mean by collation recursive stored procedure?

1112


What is an indexing strategy?

1074