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.
BY Best Interview Question ON 18 Mar 2020