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