Oracle 1Z0-117 問題集

質問 1：
You enable auto degree of parallelism (DOP) for your database instance. Examine the following query:

Which two are true about the execution of statement?
A. The statement will be queued if the number of busy parallel execution servers exceeds PARALLEL_SERVERS_TARGET.
B. Auto DOP is used to determine the statement DOP only if the estimated serial execution time exceeds PARALLEL_MIN_TIME_THRESHOLD.
C. The statement will be queued if insufficient parallel execution slaves are available to satisfy the statements DOP.
D. The statements may execute serially.
E. Dictionary DOP is used to determine the statement DOP only if the estimated serial execution time exceeds PARALLEL_MIN_TIME_THRESHOLD.
F. Dictionary DOP for the objects accessed by the query is used to determine the statement DOP.
正解：D,F
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You identified some DSS queries that perform expensive join and aggregation operations.
The queries access historical data from noncurrent partition of the fact tables.
What three actions could you perform to improve the response time of the queries without modifying the SQL statements?
A. Create an STS for the statements, run SQL Tuning Advisor for the STS, and implement any generated recommendations for materialized views.
B. Create an STS for the statements, run SQL Access Advisor for the STS, and implement any generated recommendations for materialized views.
C. Set QUERY_REWRITE_ENABLED to TRUE at the instance level.
D. Set the QUERY_REWRITE_ENABLED to TRUE at the session level.
E. Set QUERY_REWRITE_INTEGRITY to ENFORCED at the instance level.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
An application accessing your database got the following error in response to SQL query: ORA-12827: insufficient parallel query slaves available
View the parallel parameters for your instance:

No hints are used and the session use default parallel settings.
What four changes could you make to help avoid the error and ensure that the query executes in parallel?
A. Increase PARELLEL_SERVERS_TARGET.
B. Increase PARELLEL__MIN_TIME_THRESHOLD.
C. Decrease PARELLEL_MIN_TIME_THRESHOLD.
D. Increase PARELLEL_MIN_SERVERS.
E. Increase the value of PARELLEL_MAX_SERVERS.
F. Decrease PARELLEL_MIN_PERCENT.
G. Set PARELLEL_DEGREE_POLICY to AUTO.
正解：A,B,F,G
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Partial details of an execution plan.

Which statement correctly describes the BITMAP AND operation?
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 fact table rows that join with qualified dimension table rows from all dimension tables.
C. It produces a bitmap, representing dimension table rows from all dimension tables that join with qualified fact table rows.
D. It produces a concentration of the bitmaps for all dimension tables.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine the Exhibit 1 to view the structure of and indexes for EMPLOYEES and DEPARTMENTS tables.


Which three statements are true regarding the execution plan?
A. The in-line query in the select list is processed as a view and then joined.
B. The view operator collects all rows from a query block before they can be processed but higher operations in the plan.
C. The optimizer pushes the equality predicate into the view to satisfy the join condition.
D. The optimizer chooses sort-merge join as a join method because an equality predicate is used for joining the tables.
E. The optimizer chooses sort-merge join because sorting is required for the join equality predicate.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)