Online Access Free 1Z0-117 Practice Test

You execute the following query:

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

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

Examine Exhibit1 to view the query and its AUTOTRACE output.

Which two statements are true about tracing?

• A.The execution plan generated can be viewed from v$SQLAREA.
• B.The displayed plan will be stored in PLAN_TABLE.
• C.The displayed plan may not necessarily be used by the optimizer.
• D.Subsequent execution of this statement will use the displayed plan that is stored in v$SQL.
• E.The query will not fetch any rows; it will display only the execution plan and statistics.

Examine the Exhibit and view the structure of an indexes for the EMPLOYEES table.

Which two actions might improve the performance of the query?

• A.Decrease the value for the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter.
• B.Decrease the index on the EMPLOYEE_ID if not being used.
• C.Set the OPTIMIZER_MODE parameter to ALL_ROWS.
• D.Collect the histogram statistics for the EMPLOYEE_ID column.
• E.Use the ALL_ROWS hint in the query.

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.ETL_GROUP sessions can collectively consume up to 64 parallel execution servers before the queuing starts for this consumer.
• D.A single OTHER_GROUPS session will execute serially once it is queued for six minutes.
• E.A single ETL_GROUP session can consume up to 32 parallel execution servers.
• F.A single ETL_GROUP session can consume up to eight parallel execution servers.

Examine the Exhibit.

Which two options are true about the execution plan and the set of statements?

• A.The query uses a partial partition-wise join.
• B.The DEPT table id dynamically distributed based on the partition keys of the EMP_RANGE_DID table.
• C.The degree of parallelism is limited to the number of partitions in the EMP_RANGE_DID table.
• D.The query uses a full partition-wise join.
• E.The server process serially scans the entire DEPT table for each range partition on the EMP_RANGE_DID table.