nerdexam
IBM

P2090-047 · Question #33

Which two conditions restrict clients from using transaction level workload balancing during COMMIT and ROLLBACK operations on a pureScale instance?

The correct answer is A. An encrypted password is used. C. PL/SQL packages or SQL/PL modules are used. See the full explanation below for the reasoning.

Question

Which two conditions restrict clients from using transaction level workload balancing during COMMIT and ROLLBACK operations on a pureScale instance?

Options

  • AAn encrypted password is used.
  • BThe secondary CF is in CATCHUP state.
  • CPL/SQL packages or SQL/PL modules are used.
  • DSequence values are used and DB2_ALLOW_WLB_WITH_SEGUENCES is enabled.
  • EThe member host which initiates the COMMIT or ROLLBACK operation is defined as

How the community answered

(63 responses)
  • A
    81% (51)
  • B
    5% (3)
  • D
    3% (2)
  • E
    11% (7)

Community Discussion

No community discussion yet for this question.

Full P2090-047 Practice