Oracle Exam 1Z0-497 Topic 7 Question 99 Discussion

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

Question #: 99
Topic #: 7

[All 1Z0-497 Questions]

Which two statements are true about shared server sessions?

ANo Program Global Area (PGA) is allocated for shared server processes.

BUser Global Area is stored in System Global Area (SGA).

CShared SQL Area is allocated from Program Global Area (PGA).

DPrivate SQL Area is allocated from Library Cache.

ELarge Pool is used for SQL work areas.

Show Suggested Answer

Suggested Answer: D

http://docs.oracle.com/cd/E11882_01/server.112/e25789/process.htm#CNCPT1254

(see database writer process (DBW))

by Tyra at Aug 06, 2024, 09:58 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Keneth

16 days ago

Nah, C is also true. Shared SQL Area is allocated from PGA. I'm feeling good about this one!

upvoted 0 times

...

Talia

17 days ago

I believe statement E is also true because Large Pool is used for SQL work areas in shared server sessions.

upvoted 0 times

...

Gilma

18 days ago

Hold on, I'm pretty sure B and E are true. User Global Area is stored in SGA, and Large Pool is used for SQL work areas.

upvoted 0 times

...

Reed

22 days ago

I think A and D are the correct statements. No PGA for shared server processes, and private SQL Area is allocated from Library Cache.

upvoted 0 times

...

Deonna

24 days ago

I agree with Sherita. Statement B makes sense in the context of shared server sessions.

upvoted 0 times

...

Sherita

29 days ago

I think statement B is true because User Global Area is indeed stored in System Global Area.

upvoted 0 times

...