Oracle 1Z0-117 問題集

質問 1：
You are logged in as the HR user and you execute the following procedure:
SQL > exec DBMS_STATS.SET_TABLE_PREFS ('HR', 'EMPLOYEES', 'PUBLISH', 'FALSE');
SQL> exec DBMS_STATS.GATHER_TABLE_STATS ('HR', 'EMPLOYEES');
Which statement is true about the newly gathered statistics?
A. They are marked as pending and stored in the pending statistics table.
B. They are used by the optimizer for all sessions.
C. They are temporary and purged when the session exits.
D. They are locked and cannot be overwritten.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which statement is true about the execution?

A. All the partitions of the SALES table are read in parallel.
B. The row with the ID column having the value 0 is the first step execution plan.
C. Rows are fetched from the indexes on the PRODUCTS table and from the SALES table using full table scan simultaneously, and then hashed into memory.
D. Rows are fetched from the SALES table, and then a hash join operator joins with rows fetched from indexes on the PRODUCTS table.
正解：D

質問 3：
Which three tasks are performed by the parallel execution coordinator process?
A. Allocating parallel execution processes from the parallel execution server pool.
B. Determining the parallel execution method for each operation in the execution plan.
C. Any serial processing that is part of the execution plan.
D. Determining the desired number of parallel execution processes
E. Managing the data flow between the producers and consumers during inter-operation parallelism.
F. Managing the data flow between the producers and consumers during intra-operation parallelism.
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You are administering a database supporting an OLTP workload. A new module was added to one of the applications recently in which you notice that the SQL statements are highly resource intensive in terms of CPU, I/O and temporary space. You created a SQL Tuning Set (STS) containing all resource-intensive SQL statements. You want to analyze the entire workload captured in the STS. You plan to run the STS through the SQL Advisor.
Which two recommendations can you get?
A. Creating composite indexes for the workload
B. Creating invisible indexes for the workload
C. Dropping unused or invalid index.
D. Combing similar indexes into a single index
E. Syntactic and semantic restructuring of SQL statements
F. Implementing SQL profiles for the statements
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

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