IBM
A2090-614 · Question #18
The following statement was used to create a table space named USER_TMP in a non- partitioned database: CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM USING (?mnt/fsystem4?…
The correct answer is B. A different buffer pool can be associated with it. See the full explanation below for the reasoning.
Question
The following statement was used to create a table space named USER_TMP in a non- partitioned database: CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM USING (?mnt/fsystem4? ?mnt/fsystem5? Which operation can be performed on the USER_TMP table space with an ALTER TABLESPACE statement?
Options
- ANew storage containers can be added to it.
- BA different buffer pool can be associated with it.
- CA hard limit can be placed on the size to which its storage containers can grow.
- DIts high water mark can be lowered and its size can be reduced to the high water mark.
How the community answered
(41 responses)- A17% (7)
- B73% (30)
- C5% (2)
- D5% (2)
Community Discussion
No community discussion yet for this question.