The following statement was used to create a table space named USER_TMP in a non-partitioned
database: CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM
USING (?mnt/fsystem4? ?mnt/fsystem5? Which operation can be performed on the USER_TMP
table space with an ALTER TABLESPACE statement?

A.
New storage containers can be added to it.

B.
A different buffer pool can be associated with it.

C.
A hard limit can be placed on the size to which its storage containers can grow.

D.
Its high water mark can be lowered and its size can be reduced to the high water mark.

Explanation: