试题详情
多项选择题 Evaluate the SQL statement DROP TABLE DEPT; Which four statements are true of the SQL statement? ()

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.

  • A,B,D,E
  • 关注下方微信公众号,在线模考后查看

热门试题