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

Question

Quizplus · Accepted Answer

The DBA can add indexes on the frequently accessed fields to improve query performance, as indexes allow for faster access to specific rows in a table. Increasing the number of columns or deleting foreign keys may not have a direct impact on query performance in this scenario, and adding alternate keys may also not necessarily improve performance.

If Performance Testing Shows That Queries Based on Frequently Accessed