Shulou(Shulou.com)06/01 Report--

Choose two.

You execute this command:

TRUNCATE TABLE depts

Which two are true?

A) It drops any triggers defined on the table.

B) It retains the indexes defined on the table.

C) It retains the integrity constraints defined on the table.

D) A ROLLBACR statement can be used to retrieve the deleted data.

E) It always retains the space used by the removed rows.

F) A FLASHBACK TABLE statement can be used to retrieve the deleted data.

Answer::BC

(analysis: the basic test site.)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.