You issued the following command: CREATE GLOBAL TEMPORARY TABLE
admin_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT
DELETE ROWS TABLESPACE tbs_t1; An index is then created on the
ADMIN_WORK_AREA temporary table. Which two statements are true regarding the
TBS_T1 tablespace in the above command?(Choose two.)
A.
It stores only the temporary table but not its indexes.
B.
It must be the default temporary tablespace of the user who issues the command.
C.
It can be a default or nondefault temporary tablespace for the database.
D.
It stores both the temporary table as well as its indexes.
E.
It must be a nondefault temporary tablespace for the database.