Define candidate key, alternate key, composite key?
Answer Posted / pratik bachchuwar
candidate key: it is the no of uniquely identified column
(or attribute) in a table.
alternate key: it is simply defined as the (no of candidate
key) - (no of primary key in a table).
composite key: it is the group of primary or uniquely
identified key which again unique in other table.
| Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
How to use online Backups?
How can you fix a poorly performing query?
Explain about normal forms?
In which table collections errors are stored.
How to combine two function together?
How would you design a database for an online site, which would average a million hits a day?
What is dbms explain in brief?
What is data modeling with example?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
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?
What are the main phases of database development?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Explain about relational database management systems?
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 the process of the user request and data generating?