Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 146549 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / kumaresan chandran
A candidate key is one that can identify each row
of a table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.
A key formed by combining at least two or more
columns is called composite key.
| Is This Answer Correct ? | 89 Yes | 27 No |
Post New Answer View All Answers
What are the key features of dbms?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
fact table and dimension table containg one to many relationship or many to one relastionship
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?
How you can make a parameterized view?
How to read and create .LDC data files which are used by linguatic dictionary.
Who are naive users?
Explain what a database is?
What is dbms and its application?
How to customize error conditions.
Which data type cannot be used as a parameter in a udf?
Which four data types cannot be used as a return type from a user-defined function?
Explain about the storage and physical database design?
What are the types of database model?
What is a database development?
