1Z0-117 試験問題を無料オンラインアクセス

View the code sequence:

Which three statements are true about the execution of this query?

• A.The optimizer uses a B* tree access path for the EMPLOYEES table.
• B.The optimizer performs bitmap conversion from row IDs.
• C.The optimizer performs bitmap conversion from the row IDs of the combined maps.
• D.The optimizer uses a bitmap access path for the EMPLOYEES table.
• E.The optimizer uses an index join as an access path.
• F.The optimizer performs bitmap conversion to row IDs of the combined maps.

You execute the following query:

Which statement is true about the usage of these hints in the query?

• A.The optimizer evaluates the subquery as a first and then filters out rows.
• B.The hint will have no effect because one of the join resultsets is an inline view.
• C.The optimizer pushes the join predicate into the inline view.
• D.The optimizer performs a join operation first and then filters out the rows.

You are administering a database supporting an OLTP application. The application runs a series of extremely similar queries the MYSALES table where the value of CUST_ID changes.
Examine Exhibit1 to view the query and its execution plan.

Examine Exhibit 2 to view the structure and indexes for the MYSALES table. The MYSALES table has 4 million records.

Data in the CUST_ID column is highly skewed. Examine the parameters set for the instance:

Which action would you like to make the query use the best plan for the selectivity?

• A.Drop the existing B* -tree index and re-create it as a bitmapped index on the CUST_ID column.
• B.Collect histogram statistics for the CUST_ID column and use a bind variable instead of literal values.
• C.Us the /*+ INDEX(CUST_ID_IDX) */ hint in the query.
• D.Decrease the value of the OPTIMIZER_DYNAMIC_SAMPLING parameter to 0.

You recently gathered statistics for a table by using the following commands:

You noticed that the performance of queries has degraded after gathering statistics. You want to use the old statistics. The optimizer statistics retention period is default.
What must you do to use the old statistics?

• A.Delete all the statistics collected after the desired time.
• B.Use the flashback to bring back the statistics to the desired time.
• C.Restore statistics from statistics history up to the desired time.
• D.Set OPTIMIZER_USE_PENDING_STATISTICS to TRUE.

Examine the Exhibit1 to view the structure of an indexes for the EMPLOYEES table.

Examine the query:
SQL> SELECT * FROM employees WHERE employees_id IN (7876, 7900, 7902);
EMPLOYEE_ID is a primary key in the EMPLOYEES table that has 50000 rows.
Which statement is true regarding the execution of the query?

• A.The query uses the INLIST ITERATOR operator to iterate over the enumerated value list, and values are evaluated using an index range scan on the EMP_EMP_ID_PK index.
• B.The query uses an index skip scan on the EMP_EMP_ID_PK index to fetch the rows.
• C.The query uses the INLIST ITERATOR operator to iterate over the enumerated value list, and values are evaluated using a fast full index scan on the EMP_EMP_ID_PK index.
• D.The query uses a fast full index scan on the EMP_EMP_ID_PK index fetch the rows.
• E.The query uses the INLIST ITERATOR operator to iterate over the enumerated value list, and values are evaluated using an index unique scan on the EMP_EMP_ID_PK index.