Define candidate key, alternate key, composite key?
- 30 Answers
- 141175 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / kamal
candidte key has following character
1 it is a combition of attributes that used to identify a database record without any extraneous data.
2 it has ability to became primary key.
3 it uniquely identifies the row in a table .there can be more than one canditate key in table ,in which one should be a primary key.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Explain about the database management systems.
Why does this query return 0?
In which table collections errors are stored.
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?
I have a few records all are same structures data, I want to store data in multiple targets how
What is the database development process?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How to combine two function together?
How to read and create .LDC data files which are used by linguatic dictionary.
Which data type cannot be used as a parameter in a udf?
What are the 18 schemas?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
How is data stored in dbms?
What is dbms explain in brief?
What are the main phases of database development?
