exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam

Exam 1z0-083 topic 1 question 127 discussion

Actual exam question from Oracle's 1z0-083
Question #: 127
Topic #: 1
[All 1z0-083 Questions]

Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)

  • A. The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
  • B. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
  • C. The entire PGA is located in the System Global Area (SGA) when using shared servers.
  • D. Sorts and Hash Joins use PGA memory.
  • E. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
RinD
Highly Voted 3 years, 2 months ago
DE correct
upvoted 9 times
Kuraudio
7 months ago
E explanation: "The UGA must be available to a database session for the life of the session. For this reason, the UGA cannot be stored in the PGA when using a shared server connection because the PGA is specific to a single process. Therefore, the UGA is stored in the SGA when using shared server connections, enabling any shared server process access to it. When using a dedicated server connection, the UGA is stored in the PGA. "
upvoted 1 times
...
...
_gio_
Most Recent 1 year, 1 month ago
Selected Answer: DE
DE excluding wrong answers, but only a specific part of Private SQL Area is located in SGA when shared server is enables
upvoted 1 times
...
ScottL
1 year, 3 months ago
DE correct. https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-architecture.html#GUID-0788EAEE-0E93-497B-9ACA-401EC0F7BCA1
upvoted 1 times
...
vkra
1 year, 5 months ago
Selected Answer: DE
DE https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-architecture.html#GUID-0788EAEE-0E93-497B-9ACA-401EC0F7BCA1
upvoted 1 times
...
hilaire
1 year, 7 months ago
D E sure
upvoted 1 times
...
nobody347
2 years, 10 months ago
D and E 100%
upvoted 3 times
...
ABAJ
3 years, 2 months ago
DE are correct answer.
upvoted 3 times
...
Rogazan
3 years, 2 months ago
I agree with DE. (https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-architecture.html#GUID-913335DF-050A-479A-A653-68A064DCCA41)
upvoted 1 times
...
ObserverPL
3 years, 2 months ago
Agree, D and E
upvoted 4 times
...
dunhill
3 years, 2 months ago
I think DE
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago