Interested to Buy Any Domain ? << Click Here >> for more details...
What are different types of Keys? Please explain all the
keys with a suitable example.
- 4 Answers
- 27267 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 resource governor in sql server?
what is the sql equivaent of the dataset relation object ?
What are the types of processing and explain each? : sql server analysis services, ssas
Find nth lowest salary or get nth lowest salary?
What is forward - only cursors / read only cursor?
Explain how does the report manager work in ssrs?
What are the differences between char and varchar in ms sql server?
Do you know what are the differences between lost updates and uncommitted dependencies?
What is difference between line feed ( ) and carriage return ( )?
What is the difference between a fill factor of 100 and 0?
What are character string data types in ms sql server?
How do you improve the performance of a SQL Azure Database?
What is @@rowcount in sql?
What is after dml trigger?
How to generate random numbers with the rand() function in ms sql server?
