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
Explain syntax for viewing, dropping and disabling triggers?
How retrieve field names from the table in SQL through JAVA code?
what's the maximum size of a row? : Sql server database administration
What is the architecture of ms sql reporting service?
What is sql server replication? : sql server replication
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Can we return Data from 4(more than 1) tables in stored procedure?
List the different index configurations possible for a table?
Can you always create a cache of a report?
Describe in brief system database.
Why is the need for data conversion transformations?
How to generate create table script on an existing table in ms sql server?
What is data source view or dsv? : sql server analysis services, ssas
What is cached report?
Do you have any idea about the tcl commands?