Multiple choice technology databases

CREATE TABLE dept(deptno NUMBER(2),dname VARCNAR2(14),1oc VARCNAR2 (13));ROLLBACK;DESCRIBE DEPTWhat is true about the set?

  1. The DESCRIBE DEPT statement displays the structure of the DEPT table

  2. The ROLLBACK statement frees the storage space occupies by the DEPT table

  3. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist

  4. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The CREATE TABLE statement is a DDL command that, in Oracle, performs an implicit COMMIT before executing. After the table is created, the ROLLBACK only affects any uncommitted DML operations (like INSERT, UPDATE, DELETE) that occurred after the implicit commit. Since no DML operations were performed, the DEPT table still exists when DESCRIBE DEPT is executed, so it will display the table structure successfully.

Keep practicing — related questions