Diff between Composite key, Alternate Key, Candidate Key,
Primary Key, Unique Key, Super Key, Foreign Key
Answer Posted / sapan saxena
Super Key: All possible keys which can identify entities in
the table uniquely.
Primary Key: uniquely identify each entity in the table and
does not contain null and duplicate vales.
Composite key: The combination of two or more than two keys
which identifies entities uniquely.
Candidate Key: Nominee for the primary key.
Alternate Key: Rest of the candidate keys which is not the
primary key.
Unique Key: Same as primary key but can accept one null key
only.
Foreign Key: A foreign key is one or more columns whose
value must exist in the primary key of another table.
Is This Answer Correct ? | 41 Yes | 2 No |
Post New Answer View All Answers
Explain following error properties?
How to use clusters?
How many tables can be joined in SQL Server?
How to use values from other tables in update statements in ms sql server?
What is serializable?
What is an execution plan? When would you use it?
What is sql collation?
What is microsoft sql server?
What is a View ? Can we insert, Update and delete a view?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Explain what are page splits? : SQL Server Architecture
Introduction of rollup clause using sum and group by clause?
When you should use a low fill factor?
How to use copy and concatenate commands in SQL?
What is usually the first word in a sql query?