nerdexam
IBM

C2040-426 · Question #35

Which of the following answers is correct in terms of maintaining the best performance from the Connections databases?

The correct answer is B. reorg.sql should be run on each DB2 database on a regular basis. See the full explanation below for the reasoning.

Question

Which of the following answers is correct in terms of maintaining the best performance from the Connections databases?

Options

  • ABackup the databases nightly with the vendor tools. Backups enable the databases to compress
  • Breorg.sql should be run on each DB2 database on a regular basis
  • Cauto-compress should be enabled on each Oracle database
  • DAnswers A & C

How the community answered

(38 responses)
  • A
    11% (4)
  • B
    82% (31)
  • C
    3% (1)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full C2040-426 Practice