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


Diff between Composite key, Alternate Key, Candidate Key,
Primary Key, Unique Key, Super Key, Foreign Key



Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Forei..

Answer / sapan saxena

Super Key: All possible keys which can identify entities in
the table uniquely.
Primary Key: uniquely identify each entity in the table and
does not contain null and duplicate vales.
Composite key: The combination of two or more than two keys
which identifies entities uniquely.
Candidate Key: Nominee for the primary key.
Alternate Key: Rest of the candidate keys which is not the
primary key.
Unique Key: Same as primary key but can accept one null key
only.
Foreign Key: A foreign key is one or more columns whose
value must exist in the primary key of another table.

Is This Answer Correct ?    41 Yes 2 No

Post New Answer

More SQL Server Interview Questions

Explain the properties of a relational table?

0 Answers  


Is it possible to replicate data from sql server to oracle? : sql server replication

0 Answers  


What are tables in sql server?

0 Answers  


Explain couple pf features of SQL server

2 Answers  


what is DTS what are tasks available

1 Answers   Wipro,


What is implicit mode in sql server?

0 Answers  


Define tempdb database?

0 Answers  


What is read uncmmited?

0 Answers  


What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,


what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  


How do I view a stored procedure in sql server?

0 Answers  


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

0 Answers   ADP, iSoft,


Categories