DELETE employees;
DESCRIBE employees;
ROLLBACK TO SAVE POINT C;
GRANT SELECT ON employees TO SCOTH
ALTER TABLE employees SET UNUSED COLUMN sal;
Select MAX(sal) FROM employees WHERE department _ id 20;
第1题：
A. DELETE employees;
B. DESCRIBE employees;
C. ROLLBACK TO SAVE POINT C;
D. GRANT SELECT ON employees TO SCOTH
E. ALTER TABLE employees SET UNUSED COLUMN sal;
F. Select MAX(sal) FROM employees WHERE department _ id 20;
第2题：
Which two statements are true about L2TP tunnels?（） (Choose two.)
第3题：
A. point-in-time recovery
B. execute the ROLLBACK command with transaction number
C. flashback the database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
第4题：
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）
第5题：
Which two statements complete a transaction? （）
第6题：
A. The Work Item is not eligible for Purge.
B. The Work Item is eligible for a Permanent purge.
C. The Work Item is eligible for a Temporary purge.
D. The Work Item is not complete because it still has "Open" Notification.
E. The Work Item is eligible for both Temporary and Permanent purge.
第7题：
Which two statements complete a transaction?（）
第8题：
A. It is possible, but transaction T3 also backs out.
B. It is possible with the NOCASCADE_FORCE option.
C. It is possible with the NONCONFLICT_ONLY option.
D. It is not possible because it has conflicts with transaction T3.
第9题：
In which two conditions are resumable statements suspended？（）
第10题：
Which two statements are true regarding transactions in an Oracle database（）