nerdexam
IBM

A2090-614 · Question #51

If the following commands complete successfully for a single partition database: CREATE DATABASE mydb; CREATE BUFFERPOOL mybp; Which statement is true?

The correct answer is A. Self tuning is enabled for the MYBP buffer pool. See the full explanation below for the reasoning.

Question

If the following commands complete successfully for a single partition database: CREATE DATABASE mydb; CREATE BUFFERPOOL mybp; Which statement is true?

Options

  • ASelf tuning is enabled for the MYBP buffer pool.
  • BThe initial size for the MYBP buffer pool is zero pages.
  • CThe database has to be restarted before the MYBP buffer pool will become active.
  • DThe page size for the MYBP buffer pool can be changed using the ALTER BUFFERPOOL

How the community answered

(19 responses)
  • A
    74% (14)
  • B
    5% (1)
  • C
    16% (3)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice