Interested to Buy Any Domain ? << Click Here >> for more details...
what is candidate key & primary key,different b/t the two?
- 3 Answers
- 5712 Views
- I also Faced
- E-Mail Answers
Answer Posted / parijatha
there is no difference between the candidate and primary key
as both derives all other attributes in the relation.The
concept of primary key came into account to make the search
easy the is whenever a candidate key is declared as primary
key the primary key attribute gets sorted which reduces the
response time
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do queries work in a database?
What is indexing in database with example?
What is the default '-sort' order for a sql?
what is storage manager?
What are the disadvantages of a query?
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD
What are the types of tables in database?
Explain the difference between two and three-tier architectures.
What is the main purpose of triggers in database?
How does distributed database work?
Explain the difference between primary and foreign key?
What is the easiest database to learn?
Define join and enlist its types.
What database does facebook use?
What is database users in dbms?
