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

（A）Create an STS for all the queries in the application and use the SQL Tuning Advisor to generate recommendations.

（B）Use DBMS_MVIEW.EXPLAIN_REWRITE to analyze whether the queries are rewritten.

（C）Create an STS for all the queries in the application and use the SQL Access Advisor to generate a recommendation for optimizing materialized views for maximum query rewrite usage and fast refresh.

（D）Create an STS for all the queries and use SQL performance Analyzer to generate recommendations for determining the regressed SQL statements.

（E）USE DBMS_ADVISOR.QUICK_TUNE to analyze the query rewrite usage of materialized views for the entire workload.

（A）The CUSTOMERS and SALES tables are scanned simultaneously in parallel and then joined in parallel.

（B）First, the CUSTOMERS table is scanned in parallel, then the SALES table is scanned in parallel, and then they are joined serially.

（C）The CUSTOMERS and SALES tables are scanned simultaneously in parallel and then joined serially.

（D）First, the SALES table is scanned in parallel, then the CUSTOMERS table us scanned in parallel, and then they are joined in parallel.

（E）First, the CUSTOMERS table is scanned in parallel, then the SALES table us scanned in parallel, and then they are joined in parallel.

（A）The created SQL profile will continuously adapt to all changes made to the database, the object, and to the system statistics over an extended length of time.

（B）The optimizer uses the new tuned plan only when a reproducible fixed plan is present.

（C）The database adds the tuned plan to the SQL plan baseline as a nonfixed plan.

（D）The database adds the tuned plan to the SQL plan baseline as a fixed plan.

（A）A schema name for the table must be used in the hint if the table us qualified in the FROM clause.

（B）Hints can be used to override the optimization approach specified with the OPTIMIZER_MODE parameter.

（C）The OPTIMIZER_FEATURES_ENABLE parameter must be set to a version supports the hints used.

（D）A statement block can have only one hint, and that hint must be immediately after SELECT, UPDATE, INSERT, MERGE, or DELETE keyword.

（E）Whenever a query uses table aliases, the hints in the query must use the aliases.

（F）The optimizer uses the execution plan with lower cost even if a hint is specified.

（A）The query will not fetch any rows; it will display only the execution plan and statistics.

（B）The displayed plan may not necessarily be used by the optimizer.

（C）Subsequent execution of this statement will use the displayed plan that is stored in v$SQL.

（D）The execution plan generated can be viewed from v$SQLAREA.

（E）The displayed plan will be stored in PLAN_TABLE.

（A）A bitmap index should be built on each of the primary key columns of the fact table(s).

（B）A bitmap index must exist on all the columns that are used in the filter predicates of the query.

（C）The STAR_TRANSFORMATION_ENABLED parameter should be set to TRUE or TEMP_DISABLE.

（D）A B-tree index should be built on each of the foreign key columns of the fact table(s),

（E）A bitmap index should be built on each of the foreign key columns of the fact table(s).

（A）Use the tkprof utility to consolidate the trace files and create an output that can directly be used for diagnostic purposes.

（B）Use all trace files as input for the tkprof utility to consolidate the trace files for a module.

（C）Use the trcess utility to consolidate all trace files into a single output file, which can then be processed by the tkprof utility.

（D）Use one trace file at a time as input for the trcess utility and use tkprof utility to consolidate all the output files for a module.

（A）Parallel execution occurs for all DML statements.

（B）Parallel execution occurs for those statements that access tables with no dictionary DOP defined.

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

（D）Parallel execution occurs for those statements that access tables with dictionary DOP defined.

（E）Parallel execution occurs for all DDL statements.

（A）DOP is calculated if the calculated DOP is 1.

（B）DOP is calculated automatically.

（C）The statement will execute with auto DOP only when PARALLEL_DEGREE_POLICY is set to AUTO.

（D）Dictionary DOP will be used, if present, on the tables referred in the query.

（E）Calculated DOP will always by 2 or more.

（A）All MVIEWS may be configured to support "refresh on demand".

（B）The defining query of an MVIEWs may be based on a populated table.

（C）All MVIEWs may be configured to support "refresh on commit"

（D）Queries that are rewritten to an MVIEW will never obtain results from the result cache.

（E）The defining query of an MVIEW may be based on non_partitioned table.