Tag Archives: 1Z0-117 Practice Exam

2014 Latest Oracle 1Z0-117 Exam Dump Free Download!

QUESTION 1
You instance has these parameter settings:
 clip_image001[6]
Which three statements are true about these settings if no hints are used in a SQL statement?

A.    A statement estimated for more than 10 seconds always has its degree of parallelism computed automatically.
B.    A statement with a computed degree of parallelism greater than 8 will be queued for a maximum of 10 seconds.
C.    A statement that executes for more than 10 seconds always has its degree of parallelism computed automatically.
D.    A statement with a computed degree of parallelism greater than 8 will raise an error.
E.    A statement with any computed degree of parallelism will be queued if the number of busy parallel execution processes exceeds 64.
F.    A statement with a computed degree of parallelism of 20 will be queued if the number of available parallel execution processes is less 5.

Answer: CEF

Continue reading