Diff between Composite key, Alternate Key, Candidate Key,
Primary Key, Unique Key, Super Key, Foreign Key
Answer / 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 |
How do I find the sql server instance name?
explain different types of jions with examples briefly?
What is bcnf normalization form?
What is the difference between varchar and varchar types?
What stored by the tempdb ? : sql server database administration
What is create command?
How to enter unicode character string literals in ms sql server?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What do you understand by intent locks?
Which tcp/ip port does sql server run on? How can it be changed?
Difference between Function and Procedure-in general?
How to run sql server 2005 books online on your local system?