Oracle
1Z0-117 · Question #1
You instance has these parameter settings: Which three statements are true about these settings if no hints are used in a SQL statement?
The correct answer is C. A statement that executes for more than 10 seconds always has its degree of parallelism computed E. A statement with any computed degree of parallelism will be queued if the number of busy parallel F. A statement with a computed degree of parallelism of 20 will be queued if the number of available. See the full explanation below for the reasoning.
Question
You instance has these parameter settings:
Which three statements are true about these settings if no hints are used in a SQL statement?
Exhibit
Options
- AA statement estimated for more than 10 seconds always has its degree of parallelism computed
- BA statement with a computed degree of parallelism greater than 8 will be queued for a maximum
- CA statement that executes for more than 10 seconds always has its degree of parallelism computed
- DA statement with a computed degree of parallelism greater than 8 will raise an error.
- EA statement with any computed degree of parallelism will be queued if the number of busy parallel
- FA statement with a computed degree of parallelism of 20 will be queued if the number of available
How the community answered
(36 responses)- A8% (3)
- B14% (5)
- C75% (27)
- D3% (1)
Community Discussion
No community discussion yet for this question.