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
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q34: All database users need full access to
Q35: What type of environment do database programmers
Q36: When the primary key cannot be null,
Q37: The DBA determines the access privileges for
Q38: Which of the following DBMS evaluation categories
Q40: Which of the following is a log
Q41: In a LAN, support for _ update
Q42: QBE is an example of a procedural
Q43: Database _ deals with the ability of
Q44: The DBA is responsible for DBMS maintenance,