OCP认证052考试最新题库及答案整理-69

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

北京CUUG整理,转载请注明,OCP讨论群:569933648 / 836361015