Which Command Takes Corrective Action on a Fragmented Index

question 6

Multiple Choice

Which command takes corrective action on a fragmented index?

• A)ALTER INDEX REORGANIZE
• B)UPDATE INDEX REBUILD
• C)REINDEX DATABASE
• D)UPDATE STATISTICS

---

Definitions:

Foreign Direct Investment

Capital allocated by a firm or person from one country into commercial interests within a different country, achieved by creating business entities or buying business resources.

Developing Countries

Nations with a lower living standard, underdeveloped industrial base, and low Human Development Index relative to other countries.

Environment Degrade

The process by which the natural environment deteriorates due to human activity or natural events, leading to negative impacts on ecosystems and human health.

Cross-Border Flows

The movement of goods, capital, services, people, and data across international borders.