what is candidate key & primary key,different b/t the two?
- 3 Answers
- 4604 Views
- I also Faced
- E-Mail Answers
Answer Posted / naz
A Candidate Key can be any column or a combination of
columns that can qualify as unique key in database. There
can be multiple Candidate Keys in one table. Each Candidate
Key can qualify as Primary Key.
A primary key is the column that uniquely identifies a
record. A primary key should be UNIQUE and never be NULL.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is the relationship?
What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?
What is dbms introduction?
dear sir please provide what question will be asked in bank it officer interview
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
Which database is best for storing large data?
What do you mean by super key, primary key, foreign key and candidate key?
How to change database dialect?
What do you understand by ‘atomicity’ and ‘aggregation’?
What are the properties of a database?
How do you notify dbpak about stored procedure?
What is openedge workgroup rdbms?
What is a candidate key in dbms?
What is data model in database?
What is use of dbms?
