Oracle 1Z0-117 問題集

質問 1：
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 メンバーにのみ表示されます)

質問 2：
You instance has these parameter settings:

Which three statements are true about these settings if no hints are used in a SQL statement?
A. A statement with a computed degree of parallelism greater than 8 will be queued for a maximum of 10 seconds.
B. A statement with any computed degree of parallelism will be queued if the number of busy parallel execution processes exceeds 64.
C. A statement that executes for more than 10 seconds always has its degree of parallelism computed automatically.
D. A statement estimated for more than 10 seconds always has its degree of parallelism computed automatically.
E. A statement with a computed degree of parallelism greater than 8 will raise an error.
F. A statement with a computed degree of parallelism of 20 will be queued if the number of available parallel execution processes is less 5.
正解：B,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three options are true about MVIEWs?
A. Queries that are rewritten to an MVIEW will never obtain results from the result cache.
B. All MVIEWS may be configured to support "refresh on demand".
C. The defining query of an MVIEWs may be based on a populated table.
D. The defining query of an MVIEW may be based on non_partitioned table.
E. All MVIEWs may be configured to support "refresh on commit"
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which statement is true about an SQL plan baselines that are fixed?
A. New plans can be added as fixed plans to the baseline by using the SQL Tuning Advisor to generate a SQL profile and by accepting the SQL profile.
B. New, better plans are added automatically as a fixed plan baseline.
C. New plan can be manually loaded to the baseline from the cursor cache or a SQL tuning set.
D. New plans are added automatically by the optimizer to the baseline and are automatically evolved.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
To accomplish this, identify the required steps in the correct order from the steps given below:
1.Use DBNMS_APPLICATION_INFO to set the name of the module
2.Use DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE to enable statistics gathering for the module.
3.Use DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE to enable tracing for the service
4.Use the trcsess utility to consolidate the trace files generated.
5.Use the tkprof utility to convert the trace files into formatted output.
A. 1, 2, 4, 5
B. 1, 2, 3, 4, 5
C. 2, 1, 4, 5
D. 1, 3, 4, 5
E. 3, 1, 2, 4, 5
F. 2, 3, 1, 4, 5
正解：B
解説: (Topexam メンバーにのみ表示されます)