1Z0-117 무료 덤프문제 온라인 액세스

Which type of SQL statement would be selected for tuning by the automatic SQL framework?

• A.Serial queries that are among the costliest in any or all of the four categories: the past week, any day in the past week, any hour in the past week, or single response, and have the potential for improvement
• B.Serial and parallel queries that top the AWR Top SQL in the past week only and have been SQL profiled by the SQL Tuning Advisor.
• C.Serial and parallel queries that are among the costliest in any or all of the four categories: the past week, and day in the past week, any hour in the past week, or a single response, and that can benefit from access method changes.
• D.Serial queries that top the AWR Top SQL in the past week only and whose poor performance can be traced to concurrency issues.
• E.Serial queries that have been tuned within the last 30days and have been SQL profiled by the SQL tuning Advisor.

How can you reduce fragmentation of an index without affecting the current transactions that are using the index?

• A.Use the ANALYZE INDEX . . . command
• B.Us the ALTER INDEX . . . REBUILD ONLINE command
• C.Use the ALTER INDEX . . . DEALLOCATE UNUSED command
• D.Use the ALTER INDEX . . . VALIDATE STRUCTURE command

See the code fragment:

You receive the following error message:
ORA-12827: insufficient parallel query slaves available
Which three parameter settings could you change to avoid this error?

• A.Set the PARALLEL_DEGREE_POLICY = LIMITED
• B.Set the PARALLEL_DEGREE_POLICY = AUTO
• C.Decrease the value of PARALLEL_MIN_PERCENT
• D.Reduce the value of PARALLEL_MIN_TIME_THRESHOLF
• E.Increase the value of PARALLEL_MAX_SERVERS
• F.Increase the value of PARALLEL_MIN_SERVERS
• G.Increase the value of PARALLEL_DEGREE_LIMIT

Examine the parallelism parameters for you instance. Now examine the DSS_PLAN with parallel statement directives:


Which two are true about the DSS_PLAN resource manager plan?

• A.An ETL_GRP sessions will be switched to URGENT_GROUPS if the session requests more than eight parallel executions servers.
• B.URGENT_GROUPS sessions will always be dequeued before sessions from other groups.
• C.ETL_GROUP sessions can collectively consume 64 parallel execution servers before queuing starts for this consumer group.
• D.URGENT_GROUP sessions will not be queued if 64 parallel execution servers are busy because their PARALLEL_TARGET_PERCENTAGE is not specified.
• E.OTHER_GROUPS sessions are queued for maximum of six minutes.

Examine the initialization parameters for a database an OLTP overload.

What is the effect of changing the value of the parameter?

• A.It influenced the optimizer to use bitmap indexes as the estimated cost conversion from bimap is rowed us reduced.
• B.It influences the optimizer to use full table scans instead of index scans as the estimated cost of full table scan is reduced.
• C.It influences the optimizer to always use the value of the parameter?
• D.It influences the optimizer to use indexes instead of full table scans as the estimated cost of the using index is reduced.