Interested to Buy Any Domain ? << Click Here >> for more details...
Diff between Composite key, Alternate Key, Candidate Key,
Primary Key, Unique Key, Super Key, Foreign Key
- 1 Answers
- 10772 Views
- I also Faced
- E-Mail Answers
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
What is log ldf?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
How do we Backup SQL Azure Data?
Which trace flags are enabled in sql server?
What is the difference between a check constraint and a rule?
Explain the microsoft sql server delete command? : SQL Server Architecture
How the authentication mode can be changed?
How can you know if the row fetched from cursor is still valid in underlying table?
What is report rendering ?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
In which tcp/ip port does sql server run? Can it be changed?
what are different types of backups available in sql server? : Sql server database administration
What is a virtual table in sql?
What are the diifferences between the ms sql server vs mysql?
Can you explain what is sql server english query?
