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

69 、 Which is true about unusable indexes?

A. Rebuilding an unusable index always requires at least twice the space of the original index

B. Rebuilding an unusable index always allows DML statements on the index's table during the rebuild.

C. Rebuilding occurs automatically when an unusable index is chosen by the optimizer when creating an execution plan

D. Rebuilding an unusable index creates a new segment after dropping the unusable index.

Correct Answer: D

Beijing CUUG collation, reprint, please indicate, OCP discussion group: 569933648 / 836361015

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.