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 the rollup operator?
What is DB Development software?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain about query and reporting.
What are the key features of dbms?
How is data stored in dbms?
Explain the cube operator?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
In which database can extended stored procedures be added?
How you can make a parameterized view?
How to use timestamp datatypes
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
How to customize error conditions.
Write the fastest query to find out how many rows exist in a table?