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
How to create a store procedure with encryption?
What is the maximum size of sql server database?
What is the function of inner join?
Why is sql server log file full?
What is local temp table?
What are constraints?
Difference between aggregate functions of sql?
How sql server executes a statement with nested subqueries?
What do you understand by sql server agent?
How do I find information about the install locations for the various instances running on a computer?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
How to connect a database with sql express.?
How can you append an identity column to a temporary table?
Why de-normalization required?
What happens if null values are involved in datetime operations?