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

Which four statements are correct about communication between parallel execution process?

• A.The number of logical pathways between parallel execution producers and consumers depends on the degree parallelism.
• B.The large pool can be used for parallel execution messages buffers.
• C.The buffer cache can be used for parallel execution message buffers.
• D.The shared pool can be used for parallel execution messages buffers.
• E.Each parallel execution process has an additional connection to the parallel execution coordinator.
• F.Communication between parallel execution processes is never required if a query uses full partition-wise joins.

Which two statements are true about index full scans?

• A.An index fast full scan multi block I/O to read the index structure in its entirely.
• B.Index nodes are not retrieved in the index order, and there fore the nodes are not in sequence.
• C.An index fast full scan reads the whole index from the lowest value to the higher value.
• D.An index fast full scan reads the index block by block.

Examine the parallelism parameters for your instance:

What are true about the execution of the query?

• A.DOP for the statement is calculated automatically.
• B.It will execute in parallel only if the LINEITEM table has a dictionary DOP defined.
• C.It will execute in parallel only if the estimated execution time is 10 or more seconds.
• D.DOP for the statement is determined by the dictionary DOP of the accessed objects.
• E.It is generated to execute in parallel.
• F.It may execute serially.

Which statement is true about an automatic SQL task?

• A.It will automatically implement SQL profiles if a three-fold benefit can be achieved and automatic profile implementation is enabled.
• B.It will attempt to tune all-long-running queries that have existing SQL profiles.
• C.It will attempt to tune the currently running SQL statements that are highly resource intensive.
• D.It will automatically implement new SQL profiles for the statements that have existing SQL profiles.
• E.It will tune all the top SQL statements from AWR irrespective of the time it takes to complete the task in a maintenance window.

You enable auto degree of parallelism (DOP) for your database instance. Examine the following query:

Which two are true about the execution of statement?

• A.Dictionary DOP is used to determine the statement DOP only if the estimated serial execution time exceeds PARALLEL_MIN_TIME_THRESHOLD.
• B.The statement will be queued if the number of busy parallel execution servers exceeds PARALLEL_SERVERS_TARGET.
• C.The statements may execute serially.
• D.Dictionary DOP for the objects accessed by the query is used to determine the statement DOP.
• E.Auto DOP is used to determine the statement DOP only if the estimated serial execution time exceeds PARALLEL_MIN_TIME_THRESHOLD.
• F.The statement will be queued if insufficient parallel execution slaves are available to satisfy the statements DOP.