Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 144707 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / palanivel
primary key:- The attribute or combination of attributes
that uniquely identifies a row or record.
Foreign Key:- an attribute or combination of attribute in a
table whose value match a primary key in another table.
Composite key:- A primary key that consistsof two or more
attributes is known as composite key
candidate key:- is a column in a table which has the
ability to become a primary key.
Alternate Key:- Any of the candidate keys that is not part
of the primary key is called an alternate key.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is an application role and explain a scenario when you would use one?
Explain about network model?
Explain the role of indexing in databases?
How is data stored in dbms?
What are the 18 schemas?
Explain about relational database management systems?
How to use online Backups?
Explain about the hierarchical model of the database?
What is dbms and its application?
What are the three types of database design?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
What is DB Development software?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How to customize error conditions.
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
