Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unuse

seenagape

10 years ago

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;

Explanation: