Q: 4 Evaluate the set of SQL statements:
CREATE TABLE dept
(deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13));
ROLLBACK;
DESCRIBE DEPT
What is true about the set?
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.
B. The ROLLBACK statement frees the storage space occupied by the DEPT table.
C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT
statement introduced before the ROLLBACK statement.
Answer: A
007上面题库的这道题目为什么答案是A呢？
------解决方案--------------------------------------------------------
请看清楚题目
下面那个是对的
只有 A是对的
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
?????
不可能啊,是我眼花还是我以前一直理解错了？？？？
DDL语句系统会自动commit的，不存在rollback的问题的啊．
------解决方案--------------------------------------------------------
表达正确一点,应该这么说: 一条DDL语句本身就是一个单独的完整的事务.
------解决方案--------------------------------------------------------
不知问题是什么啊我来也谢谢啊