which two statements complete a transaction? (Choose two)
A delete employees
B describe employees
C rollback to savepoint c;
D grant select on employees to scott
E alter table employees set unused column sal
F select max(sal) from employees where department_id = 20
答案是D、E
谁能解释下？
------解决方案--------------------
A,B,F不是，grant、alter是隐式提交，C不知道...期待高人
------解决方案--------------------
rollback会提交事务，回滚所有dml操作
但rollback to SAVEPOINTNAME
只会将事务回滚到设定的那个savepoint中
事务并未提交