Infosys interview question

In DBMS asked about - joins,delete,truncate and some basic queries