Which three statements are true about GLOBAL TEMPORARY TABLES?

Which three statements are true about GLOBAL TEMPORARY TABLES?
A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
B. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
C. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
D. A GLOBAL TEMPORARY TABLE’s definition is available to multiple sessions.
E. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
F. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

Download Printable PDF. VALID exam to help you PASS.

4 thoughts on “Which three statements are true about GLOBAL TEMPORARY TABLES?

  1. CDE

    F option is true for Global Temporary Tables ON COMMIT DELETE ROWS
    but F option is not true for Global Temporary Tables ON COMMIT PRESERVE ROWS

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.