IBM
C4040-124 · Question #35
A new DBA from a non-IBM background plans to make numerous database changes to a production PQWER7 server running IBM i, but is concerned about how to identify which DB2 indexes will require…
The correct answer is A. DB2 for IBM i rebuilds indexes automatically. See the full explanation below for the reasoning.
Question
A new DBA from a non-IBM background plans to make numerous database changes to a production PQWER7 server running IBM i, but is concerned about how to identify which DB2 indexes will require rebuilding. What should be explained to the DBA?
Options
- ADB2 for IBM i rebuilds indexes automatically
- BIBM i offers automatic Systems Managed Access Path Protection (SMAPP)
- CDB2 for IBM i provides continuous data spreading and automatic storage allocation for indexes
- DIBM Systems Director Navigator for i offers a graphical interface for performing basic DB2 tasks
How the community answered
(31 responses)- A74% (23)
- B13% (4)
- C3% (1)
- D10% (3)
Community Discussion
No community discussion yet for this question.