Get the App
SLTechnology News&Howtos  ›  Database  › 

The latest question bank and answer arrangement of OCP certification 052 exam-69

Shulou Source: shulou.com Published: 2022-06-01 05:56:40 10月02日 Update

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

Tags: Beijing answer question Bank examination Certification Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Apple Docker vpn MySQL Huawei