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
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?
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?
Explain about post-relational databases?
Explain about normal forms?
In which database can extended stored procedures be added?
What is a database development?
Which data type cannot be used as a parameter in a udf?
How long can an error message be in raiseerror function?
Write short notes on manual refreshes.
explain detail about ftp in datastage?
What are the three basic rules which are to be followed for the relational model of the database?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
How to use online Backups?
How to use timestamp datatypes
What are the three types of database design?