XYZ Interview Question

sql interview ddl dml commands truncate delete commands difference group by order by clause like operator second highest salary rank(_), dence_rank() difference primary key foreign key difference how to update existing table data