Interested to Buy Any Domain ? << Click Here >> for more details...
What Is The Difference Between Primary Key & Super Key
- 3 Answers
- 7315 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 are the types of user defined functions in sql server?
What command do we use to rename a db, a table and a column?
What is the purpose of floor function?
What is the correct order of the logical query processing phases?
In which sql server version report builder introduced?
What happens if we shrink log file in sql server?
What is the simplest way to create a new database in ms sql server?
How to retrieve error messages using mssql_get_last_message()?
What are the Advantages of using CTE in sql server?
Can you name a few encryption mechanisms in sql server?
Is it possible in sql table to have more than one foreign key?
What is partition, how will you implement it? : sql server analysis services, ssas
Describe in brief authentication modes in sql server.
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Define full outer join?
