OCP CBT Question 547

Please solve the following question.

You execute the following commands in a SQL*Plus session: ```sql DELETE FROM employees WHERE department_id = 10; SAVEPOINT sp1; UPDATE employees SET salary = salary * 1.1 WHERE job_id = 'IT_PROG'; ROLLBACK TO sp1; COMMIT; ``` What will be the state of the `employees` table after these commands are executed?

Changes made by both DELETE and UPDATE statements are committed.

Only changes made by the DELETE statement are committed.

Only changes made by the UPDATE statement are committed.

All changes are rolled back, and the table remains in its original state.