Oracle 11G OCP 1Z0-053 278

（278）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 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）

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1269710/，如需轉載，請註明出處，否則將追究法律責任。