Which of the following commands are used to terminate a transaction?
Each correct answer represents a complete solution. Choose all that apply.

A.
TRUNCATE

B.
DELETE

C.
ROLLBACK

D.
COMMIT

Explanation:
The COMMIT, ROLLBACK, and TRUNCATE commands are used to terminate a transaction. While the
first two do so explicitly, TRUNCATE does it implicitly.
Answer B is incorrect. The DELETE statement is a Data Manipulation Language (DML) statement that
is used to delete records from a table, based on the condition specified in the WHERE clause. If the
WHERE clause is omitted, all records in the table are deleted. The DELETE statement can be rolled
back.
Syntax:
DELETE [FROM] TableName
[WHERE condition];