Which of the following commands cannot be rolled back? Each correct answer represents a complete solution. (Choose two.)
Which of the following commands cannot be rolled back? Each correct answer represents a complete solution. (Choose two.)
TRUNCATE and COMMIT commands cannot be rolled back. TRUNCATE is a Data Definition Language (DDL) command that removes all rows from a table without logging individual row deletions, making it irreversible. COMMIT is a transaction control command that finalizes a transaction, making all changes permanent and thus non-reversible.
i think even truncate can be rolled back
truncate is ddl, it cannot be rolled back