Interested to Buy Any Domain ? << Click Here >> for more details...
What Is The Difference Between Primary Key & Super Key
- 3 Answers
- 7608 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
How to create and drop temp table in sql server?
What is the library index called?
What is the difference between update lock and exclusive lock?
What are the different types of Indexes available in SQL Server?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How to get the definition of a stored procedure back?
How can I check if a view exists in a sql server database?
What is the purpose of update statistics and scope_identity() function?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is normalization 1nf 2nf 3nf?
What happens if the update subquery returns multiple rows in ms sql server?
What is an indexing technique?
How do I find the query plan in sql server?
explain different types of joins? : Sql server database administration
what is memory-optimized nonclustered indexes
