Oracle Exam 1Z0-071 Topic 1 Question 93 Discussion

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

Question #: 93
Topic #: 1

Which three statements are true about GLOBAL TEMPORARY TABLES?

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

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

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

DA GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.

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

FGLOBAL TEMPORARY TABLE space allocation occurs at session start.

Show Suggested Answer

Suggested Answer: E

by Theresia at May 18, 2024, 03:16 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tyra

15 days ago

I think A, E, and F are true. GLOBAL TEMPORARY TABLEs are visible to other sessions, their rows are deleted on session termination, and the space is allocated at session start. The other statements seem a bit iffy.

upvoted 0 times

...

Chuck

20 days ago

I believe statement D is true as well, since it mentions that a GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.

upvoted 0 times

...

Denise

21 days ago

I agree with Aja. Statement E is also true as it says that rows existing at session termination will be deleted.

upvoted 0 times

...

Aja

29 days ago

I think statement A is true because it mentions that rows inserted by a session are available to other sessions.

upvoted 0 times

...