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
What are the 18 schemas?
What is dbms explain in brief?
What are the three types of database design?
How to replace not in with not exist?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What is the physical representation for a many-to-many relationship?
What are the types of database model?
Explain about network model?
Explain about post-relational databases?
What is an application role and explain a scenario when you would use one?
Who are end users in dbms?
Explain what a database is?
explain detail about ftp in datastage?
How to use timestamp datatypes