Exit 1Z0-061 Oracle Database 12c: SQL Fundamentals
Question 2 of 5
0% complete
Q2 Multiple choice

Evaluate the SQL statement

DROP TABLE DEPT:

Which four statements are true of the SQL statement? (Choose four.)

Select all that apply.

  • A

    You cannot roll back this statement.

  • B

    All pending transactions are committed.

  • C

    All views based on the DEPT table are deleted.

  • D

    All indexes based on the DEPT table are dropped.

  • E

    All data in the table is deleted, and the table structure is also deleted.

  • F

    All data in the table is deleted, but the structure of the table is retained.

  • G

    All synonyms based on the DEPT table are deleted.

Previous Next