Multiple choice softskills teamwork

Which two statements complete a transaction? (Choose two.)

  1. DELETE employees;

  2. DESCRIBE employees;

  3. ROLLBACK TO SAVEPOINT C;

  4. GRANT SELECT ON employees TO SCOTT;

  5. ALTER TABLE employeesSET UNUSED COLUMN sal;

  6. SELECT MAX(sal) FROM employees WHERE department_id = 20;
Reveal answer Fill a bubble to check yourself
D,E Correct answer
Explanation

In Oracle SQL, Data Definition Language (DDL) and Data Control Language (DCL) statements like ALTER and GRANT issue an implicit COMMIT, thereby completing the current transaction. DELETE and SELECT are DML/Query statements that do not end a transaction, and ROLLBACK TO SAVEPOINT only partially reverts it.

Keep practicing — related questions