What Is The Difference Between Primary Key & Super Key
- 3 Answers
- 6733 Views
- Accenture, I also Faced
- E-Mail Answers
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 is the security model used in sql server 2005?
What is optimistic concurrency?
Which tools are available to manage SQL Azure databases and servers?
what is difference between NULL and ISNULL in SQL Server 2008?
what is the different types of backups available in sql server? : Sql server database administration
How to remove duplicate rows from table except one?
What is tablix?
How to list all user defined functions in the current database?
What are “lock” hints?
Explain how to integrate the ssrs reports in application?
What is 1nf normalization form?
How to execute stored procedure and set temp table in sql server?
What are the difference between clustered and a non-clustered index?
Can group functions be mixed with non-group selection fields in ms sql server?
What is open database communication (odbc)?
