Diff between Composite key, Alternate Key, Candidate Key,
Primary Key, Unique Key, Super Key, Foreign Key
- 1 Answers
- 10370 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 many types of the database links?
How to convert a numeric expression from one data type to another?
What are commonly used mssql functions in php?
Explain go command in sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What are the differences between left join and inner join in sql server?
What are ddl triggers and types of ddl trigger?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is 2nf normalization?
What is the difference between cartesian product and cross join?
What does indexation mean?
What are the differences between web role and worker role?
What do you mean by subquery?
Write a program using SQL queries to find a unique entry in a table.
How do you delete a trigger?
