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 must be the default temporary tablespace of the user who issues the command.
B.
It can be a default or nondefault temporary tablespace for the database.
C.
It must be a nondefault temporary tablespace for the database.
D.
It stores both the temporary table as well as its indexes.
E.
It stores only the temporary table but not its indexes.