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?

Question

Options

• AThe DESCRIBE DEPT statement displays the structure of the DEPT table.
• BThe ROLLBACK statement frees the storage space occupies by the DEPT table.
• CThe DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
• DThe DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT

• A
  69% (27)
• B
  15% (6)
• C
  5% (2)
• D
  10% (4)

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 Incorrect Answers B: The ROLLBACK statement has nothing to do with the storage space of the DEPT table. C: The DESCRIBE DEPT statement does not produce the error. It displays the structure of the D: The COMMIT statement does not need to be introduced because implicit commit occurs on the database after creation of the table.

No community discussion yet for this question.