Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 144471 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / sonya jalil khan
candidate key:if it qualifies to uniquely select a specific
row in the table such that the data in that table depend
completely on that key and nothing else is required.the
candidate key cannot hold NULLS.the candidte key should
never change it must holds the same value for a given
occurence of an entity for the lifetime of that
entity.
example:
EMP ID , NAME,JOB,DEPARTEMENT ID
here emp id is a candidate key.becouse a minimal set of
columns that can be used to identify a single row
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How can I detect whether a given connection is blocked?
How to use online Backups?
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 network model?
How can you log an error to the server event log from a stored procedure?
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?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Which four data types cannot be used as a return type from a user-defined function?
Explain about xml databases?
Explain about query and reporting.
What is the database development process?
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?
What are the three types of database design?
What is an application role and explain a scenario when you would use one?
What are the main phases of database development?
