41 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;
这道题应该选择哪两个?并解释下其他的为什么不对(除A,B)
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;
这道题应该选择哪两个?并解释下其他的为什么不对(除A,B)
DE。题目的意思: complete a transaction,换种说法,就是找DDL 语句。
DDL create,alter等
DCL GRANT,REVOKE等