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.)

Question

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.)

Accepted Answer

B. It stores both the temporary table as well as its indexes. D. It can be a default or nondefault temporary tablespace for the database.

Answer

A. It stores only the temporary table but not its indexes.

Answer

C. It must be a nondefault temporary tablespace for the database.

Answer

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…

Question

Options

How the community answered

Community Discussion