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?
New storage containers can be added to it.
A different buffer pool can be associated with it.
A hard limit can be placed on the size to which its storage containers can grow.
Its high water mark can be lowered and its size can be reduced to the high water mark.
Want to practice for C2090-614 - DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam ?