What are different types of Keys? Please explain all the
keys with a suitable example.
- 4 Answers
- 26550 Views
- I also Faced
- E-Mail Answers
Answer Posted / abdul malik(new college)
keys-A key allows us to identify a set of attributes and
thus distinguishes entities from each other.keys also help
uniquely identify relationships,and thus distinguishes
relation with each other.
different types of keys:
(i)super key
(ii)candidate key
(iii)primary key
(iv)unique key
(v)foreign key
sk-it is a set of one or more attributes that allows us to
identify uniquely an entity set.
ck-a super key for which no subset is a superkey is called
a candidate key.
pk-In a table pk does not take no repetation and does not
allow null values.
fk-it acts as a referential order.it refers one table from
the another one.
| Is This Answer Correct ? | 53 Yes | 9 No |
Post New Answer View All Answers
What is the stored procedure?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is the default order of an order by clause?
What is a field name?
what is isolation level at dead lock?
what is the system function to get the current user's user id? : Sql server database administration
Define self join in sql server joins?
What is local temp table?
If a stored procedure is taking a table data type, how it looks?
Explain about builtinadministrator?
What is the difference between ddl and dml?
List the different normalization forms?
What are the elements of dbms?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What are database states in ms sql server?
