Oracle Oracle Database 11g Release 2 SQL Tuning 1z0-117题库.pdfVIP

s@lm@n Oracle Exam 1z0-117 Oracle Database 11g Release 2: SQL Tuning Version: 7.0 [ Total Questions: 125 ] 买题库 QQ:860424807 Oracle 1z0-117 : Practice Test Question No : 1 You instance has these parameter settings: 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: C,E,F Explanation: C (not A): PARALLEL_MIN_TIME_THRESHOLD specifies the minimum execution time a statement should have before the statement is considered for automatic degree of parallelism. By default, this is set to 30 seconds. Automatic degree of parallelism is only enabled if PARALLEL_DEGREE_POLICY is set to AUTO or LIMITED. PARALLEL_DEGREE_LIMIT integer A numeric value for this parameter specifies the maximum degree of parallelism the optimizer can choose for a SQL statement when automatic degree of parallelism is active. Automatic degree of parallelism is only enabled if PARALLEL_DEGREE_POLICY is set to AUTO or LIMITED. 2 买题库 QQ:860424807 Oracle