What Is The Difference Between Primary Key & Super Key
Answer Posted / manoj
Primary Key is a column which uniquely identifies all records in a table. For example EmployeeID column in an Employee table.
If you add another column to a PK, like (EmployeeID+FirstName) it still identifies identifies all rows uniquely, is known as Super Key.
For more interview Questions on SQL Server: http://sqlwithmanoj.wordpress.com/interview-questions/
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
what data regions are and what are the different data regions?
What is Transparent Data Encryption?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Explain difference between control flow and data flow?
Do you know concepts and capabilities of sql server?
What are drilldown reports?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is SQL Azure Firewall?
What is the tcp/ip port on which sql server runs?
What is code near application topology?
Is sql server a database?
Explain transaction server implicit?
Why normalization is used?
How connect excel to sql server?
Do you know what is user defined datatypes and when you should go for them?