IBM
A2090-614 · Question #53
A2090-614 Question #53: Real Exam Question with Answer & Explanation
Sign in or unlock A2090-614 to reveal the answer and full explanation for question #53. The question stem and answer options stay visible for context.
Question
The following statement was used to create a table space named TBSP1 in a non-partitioned database: Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unused storage space to the operating system?
Options
- AALTER TABLESPACE tbsp1 REDUCE MAX
- BALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK
- CALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;
- DALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);
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.