Oracle Database 11g Release 2: SQL Tuning - 1Z0-117무료 덤프문제 풀어보기

A. It can compensate for the lack of extended statistics to get accurate cardinality estimates for complex predicate expressions.

B. It estimates selectivity better for the filters.

C. It cannot be used for processing SQL statements in parallel.

D. It is always used for flashback queries that contain the AS OF clause.

E. It cannot be used if there is a single-table predicate in the WHERE clause.

A. It produces a bitmap, representing fact table rows that do not join with qualified dimension table rows from all dimension tables.

B. It produces a bitmap, representing dimension table rows from all dimension tables that join with qualified fact table rows.

C. It produces a concentration of the bitmaps for all dimension tables.

D. It produces a bitmap, representing fact table rows that join with qualified dimension table rows from all dimension tables.

A. By using the DBMS_TRACE package

B. By using the EXPLAIN PLAN command

C. By using the TRCSESS utility

D. By enabling the SQL_TRACE parameter for the session

E. By using the TKPROF utility

A. It produces multiple files only for DBA sessions, which can be consolidated into one formatted file using the tkprof utility.

B. It merges files pertaining to a user session scattered across different processes in a shared server configuration.

C. It produces multiple files for a service, which can be consolidated into one formatted file using the tkprof utility.

D. It merges multiple trace files and produces a formatted output file.

E. It merges multiple trace files from a particular session into one single trace file.

A. Increase the value of PARELLEL_MAX_SERVERS.

B. Increase PARELLEL_MIN_SERVERS.

C. Decrease PARELLEL_MIN_PERCENT.

D. Decrease PARELLEL_MIN_TIME_THRESHOLD.

E. Set PARELLEL_DEGREE_POLICY to AUTO.

F. Increase PARELLEL__MIN_TIME_THRESHOLD.

G. Increase PARELLEL_SERVERS_TARGET.

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

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

C. A single ETL_GROUP session can consume up to 32 parallel execution servers.

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. Urgent_group sessions collectively can consume up to 64 parallel execution servers before queuing starts for this consumer group.

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

B. Evaluating the expressions and conditions in the query

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

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

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

A. Ability to exploit parallel execution servers on remote instance

B. Reduction in the duplication of block images across multiple buffer caches

C. Reduction in CPU utilization

D. Reduction in the number of blocks accessed

E. Reduction in physical I/O for parallel queries