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
- 10857 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
Can we do dml on views?
How to delete duplicate rows in sql server?
What are relationships and mention different types of relationships in the dbms
What is inline table-value user-defined function?
Explain the collation?
What is default port number for sql server 2000?
What is the maximum size of column in sql server?
What is a fan-out query in SQL Azure?
What is the difference between count () and rowcount ()?
how you can configure a running aggregate in SSRS?
What are the tools available in market as an alternative to sql server reporting services?
What are the different acid properties?
In which format does an image save in SQL Server database ?
What is the difference between locking and multi-versioning?
what is the difference between Tabular and Matrix report?
