Define candidate key, alternate key, composite key?
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 xml databases?
What are the types of database model?
Why does this query return 0?
How can I detect whether a given connection is blocked?
Explain what a database is?
What is dbms and its application?
What are the three basic rules which are to be followed for the relational model of the database?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What is the database development process?
In which table collections errors are stored.
Which data type cannot be used as a parameter in a udf?
What is DB Development software?
What is an application role and explain a scenario when you would use one?
How you can make a parameterized view?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on