PrepAway - Latest Free Exam Questions & Answers

Which statement is true?

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

PrepAway - Latest Free Exam Questions & Answers

A.
Self tuning is enabled for the MYBP buffer pool.

B.
The initial size for the MYBP buffer pool is zero pages.

C.
The database has to be restarted before the MYBP buffer pool will become active.

D.
The page size for the MYBP buffer pool can be changed using the ALTER BUFFERPOOL
statement.

Explanation:


Leave a Reply