IBM
P2070-742 · Question #114
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
(33 responses)- A3% (1)
- B3% (1)
- C12% (4)
- D82% (27)
Community Discussion
No community discussion yet for this question.