IBM
A2090-614 · Question #18
A2090-614 Question #18: Real Exam Question with Answer & Explanation
Sign in or unlock A2090-614 to reveal the answer and full explanation for question #18. The question stem and answer options stay visible for context.
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.
Unlock A2090-614 to see the answer
You've previewed enough free A2090-614 questions. Unlock A2090-614 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.