Hexaware Technologies Data Analyst Interview Questions and Answers

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.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire triggers, while delete does.

• Truncate is used to quickly rem...read more

CTE stands for Common Table Expression, a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.

• CTEs are defined using the WITH keyword in SQL.

• They help in simplifying complex queries by breaking them into smaller, more manageable parts.

• CTEs can be recursive, allowing a query to reference itself in order to perform hierarchical or tree-like operations.