Define candidate key, alternate key, composite key?
Answer Posted / kamal
candidte key has following character
1 it is a combition of attributes that used to identify a database record without any extraneous data.
2 it has ability to became primary key.
3 it uniquely identifies the row in a table .there can be more than one canditate key in table ,in which one should be a primary key.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the maximum length of an extended property?
In which table collections errors are stored.
How to use online Backups?
Explain about normal forms?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Explain about relational operator join?
What is the physical representation for a many-to-many relationship?
How long can an error message be in raiseerror function?
In which database can extended stored procedures be added?
How would you design a database for an online site, which would average a million hits a day?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What is dbms explain in brief?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Explain the process of the user request and data generating?
Who are end users in dbms?