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
答案解析:有
微信扫一扫手机做题