Which of the Following Is a Suggested Threshold for Performing

question 37

Multiple Choice

Which of the following is a suggested threshold for performing index fragmentation maintenance?

• A)delete and recreate if the fragmentation is more than 10 percent
• B)update statistics for fragmentation more than 30 percent
• C)rebuild if the fragmentation is less than 5 percent
• D)reorganize if the logical fragmentation is between 5 and 30 percent

---

Definitions:

Short-term Memory

The memory system that collects new information. Also known as working memory.

Brain Structures

The physical configurations and parts of the brain, each serving different functions vital for human life and behavior.

Problem Drinking

The consumption of alcohol that leads to health problems, legal problems, or difficulties in relationships, work, or everyday activities.

Older Persons

Refers to individuals who are in the later stages of their life, often defined by the World Health Organization as persons aged 65 years and above.