Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between a Primary Key and a Foreign Key.
- 1 Answers
- 1886 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
Each record in a table is uniquely identified by its primary key, which also guarantees data integrity. There can only be one primary key per table, which guarantees that every record is distinct.
Conversely, a foreign key refers to the primary key in the associated table to establish a connection between two tables. By guaranteeing the validity of the link between the tables and the consistency of the data, this relationship aids in preserving referential integrity between them.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a database report?
Explain, why is rdbms better than dbms?
What is advantages of progress actional?
What is data modelling explain?
Compare non-clustered and clustered index
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?
What is the difference between internal and external schema?
How many columns are in a database table?
What is a degree of relation?
Describe reporting lifecycle?
Explain atomicity and aggregation?
Mention the differences between trigger and stored procedures
What is difference between database and server?
What is 1nf in database?
What is " group by " clause?
