Use of primary key & foreign key

Question

Accepted Answer

Primary keys uniquely identify records in a table, while foreign keys establish relationships between tables.

Primary keys ensure data integrity by enforcing uniqueness and preventing duplicate records.
Foreign keys create relationships between tables, allowing data to be linked and referenced across multiple tables.
Primary keys are typically used as foreign keys in related tables to establish relationships.
Foreign keys can be used to enforce referential integrity, ensuring that data in the related tables remains consistent.
Example: In a database for a university, the student table may have a primary key of student_id, while the course table may have a foreign key of student_id to establish the relationship between students and courses.

Top PeopleStrong Senior Application Support Engineer interview questions & answers