1Z0-117 無料問題集「Oracle Database 11g Release 2: SQL Tuning」

（A）No partition-wise join is used

（B）The SALES table is composite partitioned

（C）A full partition-wise join is used

（D）A partial partition-wise join is used

（A）A single ETL_GROUP session can consume up to eight parallel execution servers.

（B）A single ETL_GROUP session can consume up to 32 parallel execution servers.

（C）Urgent_group sessions collectively can consume up to 64 parallel execution servers before queuing starts for this consumer group.

（D）A single OTHER_GROUPS session will execute serially once it is queued for six minutes.

（E）A single OTHER_GROUPS session will execute in parallel once it is queued for six minutes.

（F）ETL_GROUP sessions can collectively consume up to 64 parallel execution servers before the queuing starts for this consumer.

（A）Makes the statistics information available to GATHER_DATABASE_STATS_JOB_PROC

（B）Writes a warning message in the alert log file

（C）Updates the existing SQL profiles for which the statistics are stale.

（D）Starts the statistics collection process by running GATHER_STATS_JOB

（A）Create an STS for the statements, run SQL Tuning Advisor for the STS, and implement any generated recommendations for materialized views.

（B）Set QUERY_REWRITE_ENABLED to TRUE at the instance level.

（C）Set the QUERY_REWRITE_ENABLED to TRUE at the session level.

（D）Create an STS for the statements, run SQL Access Advisor for the STS, and implement any generated recommendations for materialized views.

（E）Set QUERY_REWRITE_INTEGRITY to ENFORCED at the instance level.

（A）Set the CURSOR_SHARING parameter to SIMILAR.

（B）Use the RESULT_CACHE hint in the queries.

（C）Create baselines for the almost identical SQL statement by manually loading them from the cursor cache.

（D）Replace literals with bind variables and evolve a baseline for the statement.

（A）It identifies the objects with stale or missing statistics and gathers statistics automatically.

（B）It identifies the syntactic, semantic, or design problems with structure of SQL statements leading to poor performance and suggests restricting the statements.

（C）It identifies resource-intensive SQL statements, runs them through the SQL Tuning Advisor, and implements the recommendations automatically.

（D）It recommends a SQL profile to help create a better execution plan.

（E）It picks up resource-intensive SQL statements from the ADDM and recommends the use of materialized views to improve query performance.

（F）It investigates the effect of new or modified indexes on the access paths for a workload and recommends running that statistics through the SQL Access Advisor.

（A）A SELECT statement can be executed in parallel only if no scalar subqueries are contained in the SELECT list.

（B）Single row inserts are never executed is parallel.

（C）A subquery in a parallel DML is parallelized only if it includes a parallel hint.

（D）The number of parallel execution servers requested for a cursor is based on the greatest degree of parallelism associated with any object accessed by the cursor.

（E）In an INSERT INTO . . . SELECT FROM statement, INSERT is parallelized if select is parallelized.

（F）In a CREATE TABLE . . . AS SELECT (CTAS) statement, SELECT is parallelized only if create TABLE is parallelized.

（A）Create a SQL Tuning Set (STS) containing the SQL statements

（B）Gather statistics for objects used in the application

（C）Create a SQL plan baseline for each query

（D）Enable SQL plan management

（A）3, 5, 4, 7, 6

（B）4, 5, 3, 7, 6

（C）3, 4, 5, 7, 6

（D）3, 5, 4, 6, 7

（A）Use the FIRST_ROWS_n hint in the queries.

（B）Set the OPTIMIZER_DYNAMIC_SAMPLING parameter to 0.

（C）Unlock and gather statistics for the table after inserts are done and lock them again.

（D）Set the STALE_PERCENT preference to 0.

（E）Set the OPTIMIZER_MODE parameter to ALL_ROWS.