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
- 10762 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 to create function with parameter in sql server?
Can you name a few encryption mechanisms in sql server?
What is a transaction and why is it important?
What are the ways available in sql server to execute sql statements?
What are the purpose of Normalisation?
Can you tell me about the concept of ER diagrams?
Determine when to use stored procedure to complete sql server tasks?
What is merge replication?
How you can find out if an index is useful to the optimizer?
Why SQL Agent is used?
List some advantages and disadvantages of stored procedure?
State the difference between union and union all?
List out a number of the wants to setup a SQL Server failover cluster?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What samples and sample databases are provided by microsoft?
