Oracle 1Z0-117 問題集

質問 1：
Exhibit

Examine the following SQL statement:

Examine the exhibit to view the execution plan. Which statement is true about the execution plan?
A. The EXPLAIN PLAN generates the execution plan and stores it in c$SQL_PLAN after executing the query. Subsequent executions will use the same plan.
B. The rows with the ID 3 and 4 are executed simultaneously.
C. The row with the ID 0 is the first step executed in the execution plan.
D. The EXPLAIN PLAN generates the execution plan and stores it in PLAN_TABLE without executing the query. Subsequent executions will always use the same plan.
E. The row with the ID 3 is the first step executed in the execution plan.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You are administering a database supporting an OLTP workload where the users perform frequent queries for fetching a new rows as possible, involving join operations on recently
inserted data. In addition at night, a few DSS queries are also performed. Examine the initialization parameters for the instance:

Which two options would you use for the optimizer?
A. Set the OPTIMIZER_MODE initialization parameter to FIRST_ROWS_n.
B. Set the OPTIMIZER_INDEX_CACHING initialization parameter to 0.
C. Add a hint INDEX_COMBINE in all DSS queries.
D. Set the OPTIMIZER_INDEX_COST_ADJ initialization parameter to 100.
E. Add the hint ALL_ROWS in the DOS queries.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Examine the parallelism parameter for your instance:

parallel_servers_target
Now examine the resource plan containing parallel statement directives:
Consumer Group resource plan containing parallel statement directives:

Which two are true about parallel statement queuing when this plan is active?
A. Urgent_group sessions collectively can consume up to 64 parallel execution servers before queuing starts for this consumer group.
B. A single OTHER_GROUPS session will execute in parallel once it is queued for six minutes.
C. A single ETL_GROUP session can consume up to eight parallel execution servers.
D. A single ETL_GROUP session can consume up to 32 parallel execution servers.
E. A single OTHER_GROUPS session will execute serially once it is queued for six minutes.
F. ETL_GROUP sessions can collectively consume up to 64 parallel execution servers before the queuing starts for this consumer.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
See the code fragment:

You receive the following error message:
ORA-12827: insufficient parallel query slaves available
Which three parameter settings could you change to avoid this error?
A. Set the PARALLEL_DEGREE_POLICY = AUTO
B. Increase the value of PARALLEL_DEGREE_LIMIT
C. Increase the value of PARALLEL_MAX_SERVERS
D. Set the PARALLEL_DEGREE_POLICY = LIMITED
E. Decrease the value of PARALLEL_MIN_PERCENT
F. Reduce the value of PARALLEL_MIN_TIME_THRESHOLF
G. Increase the value of PARALLEL_MIN_SERVERS
正解：C,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which are the two prerequisites for enabling star transformation on queries?
A. A bitmap index should be built on each of the primary key columns of the fact table(s).
B. A B-tree index should be built on each of the foreign key columns of the fact table(s),
C. A bitmap index must exist on all the columns that are used in the filter predicates of the query.
D. A bitmap index should be built on each of the foreign key columns of the fact table(s).
E. The STAR_TRANSFORMATION_ENABLED parameter should be set to TRUE or TEMP_DISABLE.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)