Define candidate key, alternate key, composite key?
Answer Posted / raju
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:-In the candidate key the key which is not
primary key is the alternate key.
composite key:- A key formed bythe combination of 2 or more
columns is the composite key.
| Is This Answer Correct ? | 52 Yes | 24 No |
Post New Answer View All Answers
Explain the role of indexing in databases?
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
How to combine two function together?
Explain about relational operator join?
Why does this query return 0?
What are the constraints on severity level in raiseerror?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Explain about relational database management systems?
Which four data types cannot be used as a return type from a user-defined function?
How can I detect whether a given connection is blocked?
explain detail about ftp in datastage?
How you can make a parameterized view?
What is the database development process?
State the acid rules?
Explain about the hierarchical model of the database?