IBM
C2070-587 · Question #77
A consultant wants to improve application response times on an existing large IBM DB2 database for an IBM FileNet P8 Content Engine. What command/s would the consultant run on DB2 to accomplish this?
The correct answer is D. alter table <table_name> compress yes. See the full explanation below for the reasoning.
Question
A consultant wants to improve application response times on an existing large IBM DB2 database for an IBM FileNet P8 Content Engine. What command/s would the consultant run on DB2 to accomplish this?
Options
- Aalter table <table_name> compress yes;
- Balter index <index_name> compress yes;
- Calter table <table_name> reorg yes;
- Dalter table <table_name> compress yes;
How the community answered
(36 responses)- A8% (3)
- B3% (1)
- C6% (2)
- D83% (30)
Community Discussion
No community discussion yet for this question.