Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 146554 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / piyush kathayat
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 ? | 587 Yes | 62 No |
Post New Answer View All Answers
What are the constraints on severity level in raiseerror?
Explain the cube operator?
Can an extended stored procedure be called from inside a user-defined function?
What is database design and development?
Explain the role of indexing in databases?
In which table collections errors are stored.
Explain about the relational database?
Explain what a database is?
How to replace not in with not exist?
What are the key features of dbms?
Explain about relational operator join?
How can I detect whether a given connection is blocked?
Explain about relational database management systems?
State the acid rules?
Who are end users in dbms?
