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

A. The HASH GROUP BY operation is the consumer of the HASH operation.

B. The HASH operation is the consumer of the HASH GROUP BY operation.

C. The SALES table scan is a producer for the HASH JOIN operation.

D. The HASH GROUP BY operation is the consumer of the TABLE ACCESS FULL operation for the CUSTOMER table.

E. The HASH GROUP BY operation is consumer of the TABLE ACCESS FULL operation for the SALES table.

A. Step 1 is performing nested loop operation on the DEPARTMENT_ID column of the DEPARTMENTS table, which is the driven table and results returned by step 2 in the driving resultset.

B. The performance of the query can be improved by creating bitmap index on the JOB_ID column of the EMPLOYEES table.

C. The performance of the query can be improved by creating bitmapped index on the DEPARTMENT_ID column of the EMPLOYEES table.

D. Step 2 is performing nested operation on JOB_ID column of the JOBS table, which is the driven table and the EMPLOYEES table is the driven table.

E. In step 2 for every row returned by the JOBS table matching rows from the EMPLOYEES table are accessed.

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

B. It is generated to execute in parallel.

C. It may execute serially.

D. DOP for the statement is calculated automatically.

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

F. DOP for the statement is determined by the dictionary DOP of the accessed objects.

A. Separating the clauses of the SQL statement into structures that can be processed

B. Inspecting the integrity constraints and optimizing the query based on this metadata

C. Evaluating the expressions and conditions in the query

D. Gathering the statistics before creating the execution plan for the statement

E. Checking the syntax and analyzing the semantics of the statement

A. All chunks are committed together once all tasks updating all chunks are finished.

B. The user executing the anonymous PL/SQL code requires execute privilege on the DBMS_JOB package.

C. Each chunk will be committed independently as soon as the task updating that chunk is finished.

D. ALTER SESSION ENABLE PARALLEL DML must be executed in the session prior to executing the anonymous PL/SQL code.

E. The user executing the anonymous PL/SQL code requires privilege on the DBMS_SCHEDULER package.

F. The user executing the anonymous PL/SQL code must have the CREATE JOB system privilege.

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

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

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_MVIEW.EXPLAIN_REWRITE to analyze whether the queries are rewritten.

A. 4, 5, 3, 7, 6

B. 3, 5, 4, 7, 6

C. 3, 4, 5, 7, 6

D. 3, 5, 4, 6, 7

A. Determining the desired number of parallel execution processes

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

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

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

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

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

A. A single trace file is created for each session that uses the ACC_SRV service.

B. All trace information for the ACC_SRV service connected to inst1 is stored in multiple trace files, which can be consolidated by using the tkprof utility.

C. Only those SQL statements that are identified with the ACC_SRV service executed on the inst1 instance are recorded in trace files.

D. All trace information for the service connection to inst1 will be stored in a single trace file.

E. A trace file is not created because the module name is not specified.