What is a Super Key ?

 Posted by Raj.Trivedi on 6/9/2013 | Category: Sql Server Interview questions | Views: 3309 | Points: 40
Answer:

Super Key is a key which is used to define uniqueness of a row with the collection of more than one column

Eg:- There is Customer Table

The Primary Key will be CustomerID field but this cannot be termed as a Super key
.
To be a Super key we can club 2 columns such as
CustomerID and LastName of the Customer.

If we see the above eg over here we have club 2 columns and uniquely identified a ROW


Source: ASKED by Interviewer of MSolut | Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response

More Interview Questions by Raj.Trivedi