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)- A74% (14)
- B5% (1)
- C16% (3)
- D5% (1)
Community Discussion
No community discussion yet for this question.