If Performance Testing Shows That Queries Based on Frequently Accessed

question 39

Multiple Choice

If performance testing shows that queries based on frequently accessed fields are taking a long time to complete, what can the DBA do that might improve performance?

• A) increase the number of columns
• B) delete foreign keys
• C) add indexes
• D) add alternate keys

---

Definitions:

Final Control Element

The Final Control Element in a control system is the device, such as a valve or actuator, that directly manipulates the physical process based on control signals.

Integral Action

A control action in which the controller output is proportional to the duration and magnitude of the error signal, commonly used in PID controllers.

Proportional Plus Derivative

A control method in feedback system design that uses a combination of the proportional and derivative actions to improve system response and stability.