IBM
A2090-614 · Question #16
A2090-614 Question #16: Real Exam Question with Answer & Explanation
Sign in or unlock A2090-614 to reveal the answer and full explanation for question #16. The question stem and answer options stay visible for context.
Question
If the following statements are executed: CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot; What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?
Options
- AIssue an ALTER TABLESPACE statement with the 'USING sg_med' option.
- BIssue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.
- CPerform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.
- DUse the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.
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.