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
- 10795 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
How do I find information about the install locations for the various instances running on a computer?
How do you send email on SQL Server?
Describe the functionalities that views support.
What are data regions?
What is Dependency Injection and provide example?
Can you explain powershell included in sql server 2008?
How do I delete a sql server database?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is sql server schema compare? How we can compare two database schemas?
Explain important index characteristics?
Write a SQL query in order to merge two different columns into single column?
What is an indexing technique?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Why we need sql server?
What are the advantages of sql stored procedure?
