Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 146550 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
Can an extended stored procedure be called from inside a user-defined function?
How to customize error conditions.
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How to generate OIDS
How to read and create .LDC data files which are used by linguatic dictionary.
Explain about post-relational databases?
What is normalization? Explain different levels of normalization?
Explain about network model?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
How to use timestamp datatypes
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
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?
Explain about relational operator join?
Explain about the hierarchical model of the database?
