Interested to Buy Any Domain ? << Click Here >> for more details...
What Is The Difference Between Primary Key & Super Key
- 3 Answers
- 7413 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
Explain various On-Delete options in a DB table. Which is the default option?
How to override dml statements with triggers?
Can we use trigger new in before insert?
How do you identify a foreign key?
Explain optimistic and pessimistic concurrency?
What are partitioned views?
How to generate create procedure script on an existing stored procedure?
Can you explain what is the use of custom fields in report?
What is report rendering ?
What is the difference between set and select?
How do I install only the client tools of sql server 2000?
Please differentiate between a local and a global temporary table?
What is difference between rownum and rowid?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Can we insert data if clustered index is disabled?
