Online Access Free 1Z0-117 Practice Test

Examine the following command:

Which query transformation technique is used by the optimizer in this case?

• A.Predicate pushing
• B.Predicate move-around
• C.Filter push-down
• D.View merging

An application accessing your database got the following error in response to SQL query: ORA-12827: insufficient parallel query slaves available
View the parallel parameters for your instance:

No hints are used and the session use default parallel settings.
What four changes could you make to help avoid the error and ensure that the query executes in parallel?

• A.Decrease PARELLEL_MIN_PERCENT.
• B.Increase PARELLEL_SERVERS_TARGET.
• C.Increase PARELLEL_MIN_SERVERS.
• D.Increase PARELLEL__MIN_TIME_THRESHOLD.
• E.Decrease PARELLEL_MIN_TIME_THRESHOLD.
• F.Set PARELLEL_DEGREE_POLICY to AUTO.
• G.Increase the value of PARELLEL_MAX_SERVERS.

You want to run SQL Tuning Advisor statements that are not captured by ADDM, AWR, and are not in the library cache.
What is the prerequisite?

• A.Gather statistics for objects used in the application
• B.Create a SQL plan baseline for each query
• C.Create a SQL Tuning Set (STS) containing the SQL statements
• D.Enable SQL plan management

Examine the exhibit to view the query and its execution plan?

What two statements are true?

• A.The HASH GROUP BY operation is the consumer of the TABLE ACCESS FULL operation for the CUSTOMER table.
• B.The HASH GROUP BY operation is the consumer of the HASH operation.
• C.The HASH GROUP BY operation is consumer of the TABLE ACCESS FULL operation for the SALES table.
• D.The SALES table scan is a producer for the HASH JOIN operation.
• E.The HASH operation is the consumer of the HASH GROUP BY operation.

Which statement is true about the usage of the STAR_TRANSFORMATION hint in a query?

• A.The optimizer uses transformation only if the cost is less than a query executing without transformation.
• B.The optimizer always generates subqueries to transform a query.
• C.The optimizer always uses bitmap indexes on the primary key column for any dimension table to transform a query.
• D.The optimizer always uses a plan in which the transformation is used.