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 returns an error ORA-04043: object DEPT does not exist.
B.
The DESCRIBE DEPT statement displays the structure of the DEPT table.
C.
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a
COMMIT statement introduced before the ROLLBACK statement.
D.
The ROLLBACK statement frees the storage space occupied by the DEPT table.
Explanation:
The structure of the DEPT table will be displayed because the CREATE TABLE statement is DDL
operation and it cannot be rolled back because implicit commit occurs on the database when a
user exits SQL*Plus or issues a data-definition language (DDL) command such as a create table
statement, user to create a database object, or an alter table statement, used to alter a database
object.