What are different types of Keys? Please explain all the
keys with a suitable example.
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
Explain system scalar functions?
Explain time data type in sal server 2008?
What are out-of-range errors with date and time literals?
What is a cache in ssrs?
Why olap is used?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What are the main sources of data?
What are the 7 disadvantages to a manual system?
What happens if you add a new index to large table?
What are data regions?
What is Dependency Injection and provide example?
Call by value and call by reference in procedure and function, with NOCOPY.
what's the difference between delete table and truncate table commands? : Sql server database administration
Explain transaction server consistency?
how to define testing of network layers? : Sql server database administration