Question

Which of the following statements about COMMIT and ROLLBACK commands is incorrect?​

	A.	​All DML commands (INSERT, UPDATE, DELETE) are explicitly committed and cannot be rolled back.
	B.	​All DDL commands (CREATE, TRUNCATE, ALTER TABLE) are explicitly committed and cannot be rolled back.
	C.	​A ROLLBACK command will reverse all DDL operations performed since the last COMMIT was performed.
	D.	​all of the above

Answer 1

All DML commands (INSERT, UPDATE, DELETE) are explicitly committed and cannot be rolled back. - False

they are temporary until explicitly committed

All DDL commands (CREATE, TRUNCATE, ALTER TABLE) are explicitly committed and cannot be rolled back - False

Database performs implicit commit before and after a DDL statement. So you don't have to perform a commit explicitly when it comes to DDL statement.

A ROLLBACK command will reverse all DDL operations performed since the last COMMIT was performed. - False

DDL operations are automatically committed and cannot be rolled back

--------------------------------------------------------------------------------------------------------------------------------------------------------------

So correct answer will be D