Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 146655 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / koteswararao bora
candidate key:the minimum set of attributes which uniquely
identifies the touples in a table .
primary key:any candidate key choosen by the developer is
called primary key.
composite key: a candidate key which have more than one
attribute is called composite key.
alternate key: a candidate key other than primary key
is called alternate key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain about the hierarchical model of the database?
What is the maximum length of an extended property?
Write the fastest query to find out how many rows exist in a table?
In which table collections errors are stored.
What is DB Development software?
How to generate OIDS
Explain about query and reporting.
How to replace not in with not exist?
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?
How to use timestamp datatypes
Write short notes on manual refreshes.
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 a primary key?
How you can make a parameterized view?
What are the three basic rules which are to be followed for the relational model of the database?
