Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? (Choose four)

The correct answer is A. You cannot roll back this statement. B. All pending transactions are committed. 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. You cannot roll back DROP TABLE statement. All pending transactions related on this table are If the table is dropped, Oracle automatically drops any index, trigger and constraint associated with the table as well. All data in the table is deleted, and the table structure is…

Using DDL Statements to Create and Manage Tables

Question

Evaluate the SQL statement DROP TABLE DEPT:

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

Options

AYou cannot roll back this statement.
BAll pending transactions are committed.
CAll views based on the DEPT table are deleted.
DAll indexes based on the DEPT table are dropped.
EAll data in the table is deleted, and the table structure is also deleted.
FAll data in the table is deleted, but the structure of the table is retained.
GAll synonyms based on the DEPT table are deleted.

How the community answered

(37 responses)

A
76% (28)
C
8% (3)
F
14% (5)
G
3% (1)

Explanation

You cannot roll back DROP TABLE statement. All pending transactions related on this table are If the table is dropped, Oracle automatically drops any index, trigger and constraint associated with the table as well. All data in the table is deleted, and the table structure is also deleted.

Topics

#DROP TABLE#DDL side effects#indexes dropped#auto-commit

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice