Define candidate key, alternate key, composite key?
Answer Posted / deepak v
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 ? | 122 Yes | 50 No |
Post New Answer View All Answers
Why does this query return 0?
What is a database development?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Explain the rollup operator?
Explain about the database management systems.
What is the maximum length of an extended property?
Explain about query and reporting.
What are data modelling techniques?
How to customize error conditions.
fact table and dimension table containg one to many relationship or many to one relastionship
Who are end users in dbms?
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?
Write short notes on manual refreshes.
What are the three types of database design?
How can you fix a poorly performing query?