Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145538 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / viresh rajput
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:-A candidate key uniquely identifies the rows
in a table.there can be more than 1 candidate key in a
table, in which one should be 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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
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 dbms and its application?
What is the database development process?
How can you log an error to the server event log from a stored procedure?
What are the constraints on severity level in raiseerror?
Explain about the storage and physical database design?
Which four data types cannot be used as a return type from a user-defined function?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
What is the maximum length of an extended property?
What is data modeling with example?
Explain the role of indexing in databases?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain about normal forms?
explain detail about ftp in datastage?
Write the fastest query to find out how many rows exist in a table?
