Oracle
1Z0-054 · Question #152
Which two activities can be identified as common unscalable causes of suboptimal database performance? (Choose two.)
The correct answer is B. applications generating dynamic SQL C. large amounts of recursive SQL executed by SYS. See the full explanation below for the reasoning.
Question
Which two activities can be identified as common unscalable causes of suboptimal database performance? (Choose two.)
Options
- Adefining multiple buffer pools
- Bapplications generating dynamic SQL
- Clarge amounts of recursive SQL executed by SYS
- Drecursive SQL executed by a user other than SYS
- Eusing cursors with bind variables that open the cursor and execute it many times
How the community answered
(35 responses)- A11% (4)
- B80% (28)
- D6% (2)
- E3% (1)
Community Discussion
No community discussion yet for this question.