Oracle 1Z0-117 問題集

質問 1：
You have enabled DML by issuing: ALTER session ENABLE PARALLEL DML;
The PARELLEL_DEGREE_POLICY initialization parameter is set to AUTO.
Which two options true about DML statements for which parallel execution is requested?
A. Statements for which PDML is requested will be queued if the number of busy parallel execution servers greater than PARALLEL_MIN_SERVERS parameter.
B. Statement for which PDML is requested will be queued if the number of busy parallel execution servers is greater than PARELLEL_DEGREE_LIMIT parameter.
C. Statements for which PDML is requested will execute serially estimated time is less than the time specified by the PARALLEL_MIN_THRESHOLD parameter.
D. Statements for which PDML is requested will always execute in parallel if estimated execution in parallel if estimated execution time is greater than the time specified by the PARELLEL_MIN_TIME_THRESHOLD parameter.
E. Statements for which PDML is requested will be queued if the number of busy parallel execution servers is greater than PARELLEL_SERVERS_TARGET parameter.
正解：D,E
解説: (Topexam メンバーにのみ表示されます)

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

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

質問 4：
How can you reduce fragmentation of an index without affecting the current transactions that are using the index?
A. Use the ALTER INDEX . . . DEALLOCATE UNUSED command
B. Use the ANALYZE INDEX . . . command
C. Us the ALTER INDEX . . . REBUILD ONLINE command
D. Use the ALTER INDEX . . . VALIDATE STRUCTURE command
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine the query and its execution plan:

Which statement is true regarding the execution plan?
A. This query first fetches rows from the CUSTOMERS table that satisfy the conditions, and then the join return NULL from the CUSTOMER_ID column when it does not find any corresponding rows in the ORDERS table.
B. The query first fetches rows from the ORDERS table that satisfy the conditions, and then the join returns NULL form CUSTOMER_ID column when it does not find any corresponding rows in the CUSTOMERS table.
C. The query fetches rows from CUSTOMERS and ORDERS table simultaneously, and filters the rows that satisfy the conditions from the resultset.
D. The query first joins rows from the CUSTOMERS and ORDERS tables and returns NULL for the ORDERS table columns when it does not find any corresponding rows in the ORDERS table, and then fetches the rows that satisfy the conditions from the result set.
正解：A