최신 1Z0-117 무료덤프 - Oracle Database 11g Release 2: SQL Tuning

A. A statement with any computed degree of parallelism will be queued if the number of busy parallel execution processes exceeds 64.

B. A statement with a computed degree of parallelism greater than 8 will be queued for a maximum of 10 seconds.

C. A statement with a computed degree of parallelism greater than 8 will raise an error.

D. A statement estimated for more than 10 seconds always has its degree of parallelism computed automatically.

E. A statement with a computed degree of parallelism of 20 will be queued if the number of available parallel execution processes is less 5.

F. A statement that executes for more than 10 seconds always has its degree of parallelism computed automatically.

A. The instance collects statistics and based on the pattern of executions creates a histogram on the column containing the bind value.

B. The value for the bind variable will considered by the optimizer to determine the execution plan.

C. Bind peeking will take place only for the first execution of the statement and subsequent execution will use the same plan.

D. The same execution plan will always be used irrespective of the bind variable value.

E. The DEPTNO column will become bind aware once histogram statistics are collected.

A. Rows from the DEPT table are first hashed by the join key into memory and then joined to the EMP table on the join key.

B. Rows from both the tables are sorted by the join key, but only rows from the DEPT table are hashed into memory.

C. The DEPT table is driving table and the EMP table join is the driven table.

D. The EMP table is the driving table and the DEPT table us the driven table.

E. The rows from the DEPT table are sorted first by the join key and then hashed into memory.

A. Parallel execution occurs for those statements that access tables with no dictionary DOP defined.

B. Parallel execution occurs for all DML statements.

C. Parallel execution occurs when estimated serial execution time exceeds the minimum time threshold.

D. Parallel execution occurs for all DDL statements.

E. Parallel execution occurs for those statements that access tables with dictionary DOP defined.

A. Queuing is done for a consumer group exceeding its percentage, even if the number of busy PX servers in the instance has not reached PARALLEL_SERVERS_TARGET.

B. Having separate queues for consumer groups requires the use of management attributes (MGMT_P1, MGMT_P2 etc. . . )

C. Separate queue timeout using PARALLEL_QUEUE_TIMEOUT require the use of management attributes (MGMT_P1, MGMT_P2 etc . . . groups)

D. PARALLEL_TARGET_PERCENTAGE is used to prioritize a consumer group's use of the overall PARALLEL_SERVER_TARGET.

E. PARALLEL_TARGET_PERCENTAGE us used to prioritize a consumer group's use of the overall SPAN CLASS = 'OracleCode'> PARALLEL_MAX_SERVERS.

A. Adaptive cursor sharing happens only if there is a histogram in the REIGN column of the CUSTOMERS table.

B. The literal value 'NORTH' is replaced by a system-generated bind variable.

C. Bind peeking will not happen and subsequent executions of the statement with different literal values will use the same plan.

D. Adaptive cursor sharing happens irrespective of whether there is a histogram in the REIGN column of the CUSTOMERS table.

A. Too many similar type of queries getting executed with cursor sharing disabled

B. Highly selective filter on indexed columns

C. Histograms statistics not available

D. Indexes not built on filter columns

E. Too many sort operations performed by queries

A. Managing the data flow between the producers and consumers during inter-operation parallelism.

B. Determining the desired number of parallel execution processes

C. Determining the parallel execution method for each operation in the execution plan.

D. Managing the data flow between the producers and consumers during intra-operation parallelism.

E. Any serial processing that is part of the execution plan.

F. Allocating parallel execution processes from the parallel execution server pool.

A. By using the TRCSESS utility

B. By enabling the SQL_TRACE parameter for the session

C. By using the DBMS_TRACE package

D. By using the TKPROF utility

E. By using the EXPLAIN PLAN command

A. Serial queries that are among the costliest in any or all of the four categories: the past week, any day in the past week, any hour in the past week, or single response, and have the potential for improvement

B. Serial and parallel queries that top the AWR Top SQL in the past week only and have been SQL profiled by the SQL Tuning Advisor.

C. Serial and parallel queries that are among the costliest in any or all of the four categories: the past week, and day in the past week, any hour in the past week, or a single response, and that can benefit from access method changes.

D. Serial queries that top the AWR Top SQL in the past week only and whose poor performance can be traced to concurrency issues.

E. Serial queries that have been tuned within the last 30days and have been SQL profiled by the SQL tuning Advisor.