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
How to fetch the next row from a cursor with a "fetch" statement?
What is query parameter in ssrs?
how can u get last observation in an unknown dataset ?
How can you check the version of sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Explain a differential backup?
Can you move the resources after pausing the node? : sql server database administration
Explain different types of self contained sub query?
How to Check if table exists in sql server?
Define views.
How we can refresh the view?
What is sql injection and why is it a problem? : sql server security
What is difference between Datepart() and Datename() in SqlServer?
How can I get data from a database on another server?
What is self contained sub query?