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 to download and install microsoft .net framework version 2.0?

1105


What are the requirements to use odbc connections in php scripts?

1061


Explain security with sql azure?

186


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1070


What is the use of stored procedure?

895


Can you always create a cache of a report?

156


Define compound operators?

863


What is sql server transaction log file?

994


Explain what is dbcc?

964


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2045


What is an indexed view?

919


What is RMS migrations?

2088


Explain transaction isolation levels in sql server?

1038


What is the exact numeric data type in sql?

962


How to find out what is the default collation in a database?

1064