Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145621 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
Explain about xml databases?
Can an extended stored procedure be called from inside a user-defined function?
Why does this query return 0?
What are the key features of dbms?
Explain about the relational database?
What are the three types of database design?
Explain what a database is?
Explain about the storage and physical database design?
Explain the rollup operator?
Which four data types cannot be used as a return type from a user-defined function?
What is an application role and explain a scenario when you would use one?
Which data type cannot be used as a parameter in a udf?
Explain the role of indexing in databases?
What are the three basic rules which are to be followed for the relational model of the database?
What is normalization? Explain different levels of normalization?
