Define candidate key, alternate key, composite key?
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 a database development?
What are the main phases of database development?
Where is dbms used?
Explain about a primary key?
What are the types of database model?
Which four data types cannot be used as a return type from a user-defined function?
Explain about post-relational databases?
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 can you fix a poorly performing query?
What is normalization? Explain different levels of normalization?
How to generate OIDS
Explain about the database management systems.
How is data stored in dbms?
How to replace not in with not exist?
How to use online Backups?