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?

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?

Accepted Answer

C. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;

Answer

A. ALTER TABLESPACE tbsp1 REDUCE MAX

Answer

B. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK

Answer

D. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);

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…