多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题