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
Which sql server is best?
What is the difference between drop table and truncate table?
How can I check that whether automatic statistic update is enabled or not?
What is the importance of concurrency control?
Explain how you can deploy an SSRS report?
What are the advantages of using cte?
What is a coalesce function?
Explain the dbcc pintable command when would you use it?
What is pessimistic concurrency?
Differentiate sql server reporting services vs. Crystal reports?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is an etl file?
How to return the top 5 rows from a select query in ms sql server?
How to get a list of all tables with "sys.tables" view in ms sql server?
Where views are stored in sql server?