Maventic interview question

How do we do CRUD operations in DBMS? How to join two tables with foreign key?