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?
A. ALTER TABLESPACE tbsp1 REDUCE MAX
B. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK
C. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);
D. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;
|
Download Printable PDF. VALID exam to help you PASS. |
 |