What is the difference between primary and foreign key?
|S.no||Primary Key||Foreign Key|
|1.||Value cannot be NULL||Value can be NULL|
|2.||Duplicate values not allowed||Duplicate values are allowed|
|3.||The primary key can only be one||There can be multiple foreign key|
Point to be noted:- Go through this Q&A very thoroughly as this is one of the critical RDBMS interview questions.