Interested to Buy Any Domain ? << Click Here >> for more details...
What Is The Difference Between Primary Key & Super Key
- 3 Answers
- 7470 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
Do you know what is sql injection?
What are the encryption mechanisms in sql server?
What is isolation levels?
How many tables can be joined in SQL Server?
What are the steps to follow to configure SQL*Net?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
what's the maximum size of a row? : Sql server database administration
List some major differences between triggers and stored procedures?
What is bcp? When does it used?
How to populate a table in sql server?
Introduction of rollup clause using sum and group by clause?
Explain the properties of sub-query in sql server?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What are the methods used to protect against sql injection attack?
How can I change procedure name in sql server?
