What are different types of Keys? Please explain all the
keys with a suitable example.
- 4 Answers
- 26551 Views
- I also Faced
- E-Mail Answers
Answer Posted / rishit v chandarana
there are main 5 types of key, namely
candidate key,
primary key,
alternative key,
secondary key &
foreign key i.e refrential key.
Ck- all keys in a table.
Pk- selected key in a table.
Al- not selected as a pk key in a table.
Sk- not selected at all.
Rk- key showing refrence at other table.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Does a full backup include transaction log?
Explain sql delete command?
Is sql server 2016 free?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is the difference between Triggers and Stored Procedure?
What are four major operators that can be used to combine conditions on a where clause?
New concepts of sql server 2005 use in your project.
What are “lost updates”?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Can select statements be used on views in ms sql server?
What is difference between clustered index and non clustered index?
How to download microsoft sql server 2005 express edition?
What is table level trigger?
How many servers can we create in a single subscription?
What are sql dirty pages?
