Define candidate key, alternate key, composite key?
Answer Posted / shiv om mishra
candidate key- is a combination of two attributes taht can be uniquely used to identify a datbase record without any extraneous data.
Each table may have one or more candidate key.
A candidate key of a relation tells us all teh set of all its attribute is a superkey.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
explain detail about ftp in datastage?
Who are naive users?
In which table collections errors are stored.
In which database can extended stored procedures be added?
Explain the role of indexing in databases?
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?
Why does this query return 0?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What is dbms and its application?
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 the hierarchical model of the database?
What is database design and development?
How to read and create .LDC data files which are used by linguatic dictionary.
How to combine two function together?