Define candidate key, alternate key, composite key?
Answer Posted / zulfiqar ali
ANSWER 22.. 1 A candidate key is the combination of one or
more attributes which is used to identify records uniquely a
candidate can be selected as a primary key.
2 A key which is not selected is called Alternate key.
3 combination of attributes is called composite key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the three types of database design?
explain detail about ftp in datastage?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
How to generate OIDS
How to use online Backups?
What are the three basic rules which are to be followed for the relational model of the database?
How to customize error conditions.
Explain about xml databases?
Write short notes on manual refreshes.
How long can an error message be in raiseerror function?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What is normalization? Explain different levels of normalization?
Where is dbms used?
Explain about post-relational databases?
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?