Oracle
1Z0-050 · Question #100
1Z0-050 Question #100: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #100. The question stem and answer options stay visible for context.
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.)
Options
- AIt stores only the temporary table but not its indexes.
- BIt stores both the temporary table as well as its indexes.
- CIt must be a nondefault temporary tablespace for the database.
- DIt can be a default or nondefault temporary tablespace for the database.
- EIt must be the default temporary tablespace of the user who issues the command.
Unlock 1Z0-050 to see the answer
You've previewed enough free 1Z0-050 questions. Unlock 1Z0-050 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.