Oracle
1Z0-074 · Question #66
You want to restrict PGA usage to 200 MB for a set of database users' sessions as part of your organization's security requirements for combating denial of service (DOS) attacks. Which statement is…
The correct answer is C. You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB. Explanation/Reference: https://oracle-base.com/articles/12c/pga_aggregate_limit_12cR1
New Features for Security
Question
You want to restrict PGA usage to 200 MB for a set of database users' sessions as part of your organization's security requirements for combating denial of service (DOS) attacks. Which statement is true about limiting PGA usage for those users' sessions?
Options
- AYou can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.
- BYou cannot limit PGA for a set of database user sessions.
- CYou can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.
- DYou can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.
- EYou can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database
How the community answered
(44 responses)- A2% (1)
- B2% (1)
- C82% (36)
- D5% (2)
- E9% (4)
Explanation
Explanation/Reference: https://oracle-base.com/articles/12c/pga_aggregate_limit_12cR1
Topics
#PGA_AGGREGATE_LIMIT#resource management#DOS protection#memory limits
Community Discussion
No community discussion yet for this question.