Which two statements are true regarding the TBS_T1 tablespace in the above 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? (Choose two.)

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 must be the default temporary tablespace of the user who issues the command.

B.
It can be a default or nondefault temporary tablespace for the database.

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

D.
It stores both the temporary table as well as its indexes.

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *