What are different types of Keys? Please explain all the
keys with a suitable example.
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
What does top operator do?
What is sub-query in sql server? Explain its properties.
what is memory-optimized nonclustered indexes
How to send email from database?
How to generate create procedure script on an existing stored procedure?
What is sql server management studio? : sql server management studio
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Explain forward - only cursors?
What are tables in sql server?
What is table valued function and scalar valued functions?
What is a mixed extent?
When would you use the stored procedures or functions?
Equi join and non equi join is possible with sql server?
How to start sql server browser service?
Write a sql query to display the current date?