Define candidate key, alternate key, composite key?
- 30 Answers
- 141167 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / sonal singhal
Candidate keys-> A candidate key is a combination of
attributes that can be uniquely used to identify a database
record without any extraneous data. Each table may have one
or more candidate keys. One of these candidate keys is
selected as the table primary key.
Alternate keys-> Alternate Key or Unique Key is similar to
PK ,except it accepts null Values .So that the records can
still be entered submitting null values to this attribute.
Composite keys-> compound key (also called a composite key
or concatenated key) is a key that consists of 2 or more
attributes.
A composite Key can be either Primay or Unique
Key.More then One Key columns are said to be composite keys
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What is data modeling with example?
Explain the cube operator?
How long can an error message be in raiseerror function?
Can an extended stored procedure be called from inside a user-defined function?
How you can make a parameterized view?
Write the fastest query to find out how many rows exist in a table?
What is normalization? Explain different levels of normalization?
Explain about the relational database?
What is the database development process?
Explain what a database is?
Explain about relational operator join?
What is dbms explain in brief?
What is the physical representation for a many-to-many relationship?
How to use online Backups?
