Oracle Exam 1Z0-082 Topic 11 Question 28 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 28
Topic #: 11

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

AA TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

BGLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

CGLOBAL TEMPORARY TABLE space allocation occurs at session start.

DAny GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

EA GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

FA DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Show Suggested Answer

Suggested Answer: A, D, E

by Herman at May 09, 2022, 06:26 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!