Which two statements are true regarding the TBS_T1 tablespace in the above command?

See the series of commands to be executed:

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

See the series of commands to be executed:

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



Leave a Reply 0

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