What is the difference between truncate and delete, how many types of joins in SQL and explain briefly, how many languages in SQL. etc...,

Question

Accepted Answer

Truncate is a DDL command that removes all records from a table, while delete is a DML command that removes specific records.

Truncate is faster than delete as it does not log individual row deletions.
Truncate resets identity columns, while delete does not.
Joins in SQL: Inner join, outer join (left, right, full), cross join, self join.
Languages in SQL: Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), Transaction Control Language (TCL).