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

（A）The CUSTOMERS table is scanned first and selected partitions from the SALES table are scanned based on the BLOOM Filter created during the scan of the CUSTOMERS table.

（B）The SALES table is scanned first and selected partitions from the CUSTOMERS table are scanned based on the Bloom Filter created during the scan of the SALES table.

（C）The CUSTOMERS table is hash partitioned.

（D）Both the CUSTOMERS and SALES tables are scanned simultaneously and rows from the CUSTOMERS table are joined to row of the SALES table.

（E）The CUSTOMERS table is range partitioned.

（F）The SALES table is hash partitioned.

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

（B）Histograms statistics not available

（C）Highly selective filter on indexed columns

（D）Indexes not built on filter columns

（E）Too many sort operations performed by queries

（A）Set the PUBLISH statistic preference to TRUE for these tables.

（B）Set the STALE_PERCENT static preference to a higher value for these tables.

（C）Set the INCREMENTAL statistic preference FALSE for these tables.

（D）Set the GRANULARITY statistic preference to AUTO for these tables.

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

（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）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.

（A）It will execute in parallel only if the estimated execution time is 10 or more seconds.

（B）It is generated to execute in parallel.

（C）DOP for the statement is determined by the dictionary DOP of the accessed objects.

（D）It will execute in parallel only if the LINEITEM table has a dictionary DOP defined.

（E）DOP for the statement is calculated automatically.

（F）It may execute serially.

（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）Ability to exploit parallel execution servers on remote instance

（B）Reduction in CPU utilization

（C）Reduction in the number of blocks accessed

（D）Reduction in the duplication of block images across multiple buffer caches

（E）Reduction in physical I/O for parallel queries

（A）1, 2 3, 4, 5, 6

（B）1, 4, 2, 3, 6, 5

（C）2, 3, 1, 4, 6, 5

（D）2, 4, 1, 3, 6, 5

（A）Creating composite indexes for the workload

（B）Combing similar indexes into a single index

（C）Creating invisible indexes for the workload

（D）Implementing SQL profiles for the statements

（E）Syntactic and semantic restructuring of SQL statements

（F）Dropping unused or invalid index.

（A）1, 3, 4, 5

（B）3, 1, 2, 4, 5

（C）1, 2, 3, 4, 5

（D）2, 3, 1, 4, 5

（E）1, 2, 4, 5

（F）2, 1, 4, 5