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:
Answer D, C, and AThe 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];