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
- 27575 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 an extended stored procedure? : Sql server database administration
What is the command used to recompile the stored procedure at run time?
Can sql servers link to other servers?
What is rtm version in sql server?
What are the properties of the relational tables?
Explain the difference between delete,drop and truncate in SQL Server?
Do you know what is normalization of database? What are its benefits?
How to enter binary string literals in ms sql server?
Explain the different index configurations a table can have?
What is transaction server explicit transaction?
What is temporary table in sql server? Why we use temp table?
Introduction of rollup clause using sum and group by clause?
Define cursor locking
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
