You issued the following command:CREATE GLOBAL TEMPORARY TABLE admin_work_area(startdate DATE, enddate DATE, class CHAR(

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You issued the following command:CREATE GLOBAL TEMPORARY TABLE admin_work_area(startdate DATE, enddate DATE, class CHAR(

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply