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
Explain about relational operator join?
Write short notes on manual refreshes.
How you can make a parameterized view?
I have a few records all are same structures data, I want to store data in multiple targets how
How to replace not in with not exist?
How to customize error conditions.
How to use timestamp datatypes
How to use online Backups?
Can an extended stored procedure be called from inside a user-defined function?
Where is dbms used?
How is data stored in dbms?
Explain about the hierarchical model of the database?
How can I detect whether a given connection is blocked?
Explain the role of indexing in databases?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?