问题:
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.
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?()
● 参考解析
本题暂无解析