Thoughts2Binary Python Developer Interview Questions and Answers

Primary key uniquely identifies a record in a table, while foreign key refers to a field in another table.

• Primary key is used to enforce data integrity and ensure uniqueness of records

• Foreign key is used to establish a relationship between two tables

• A table can have only one primary key, but multiple foreign keys

• Primary key is always indexed, while foreign key may or may not be indexed

• Primary key cannot have null value