Oracle
1Z0-052 · Question #22
1Z0-052 Question #22: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #22. The question stem and answer options stay visible for context.
Managing Schema Objects
Question
You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area ( startdate DATE, enddate DATE, class CHAR(20) ) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?
Options
- AThe rows stay in the table only until session termination
- BThe rows stay in the table only until the next transaction starts on the table
- CThe rows are visible to all current sessions after the transaction in committed
- DThe rows stay available for subsequent sessions after the transaction is committed
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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.
Topics
#global temporary tables#ON COMMIT PRESERVE ROWS#session scope#DDL