Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 144539 Views
- IAS, IBM, I also Faced
- E-Mail Answers
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
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
How can you fix a poorly performing query?
Who are end users in dbms?
Explain the rollup operator?
How can I detect whether a given connection is blocked?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
State the acid rules?
I have a few records all are same structures data, I want to store data in multiple targets how
Which four data types cannot be used as a return type from a user-defined function?
Explain about normal forms?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
What are data modelling techniques?
Explain about query and reporting.
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
