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.
正确答案:B,D
答案解析:有
微信扫一扫手机做题