READ Free Dumps For Oracle- 1z0-117

Question ID 2510	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?
Option A	A.    Set PARELLEL_DEGREE_POLICY to AUTO.
Option B	B.    Increase the value of PARELLEL_MAX_SERVERS.
Option C	C.    Increase PARELLEL_SERVERS_TARGET.
Option D	D.    Decrease PARELLEL_MIN_PERCENT.
Option E	E.    Increase PARELLEL_MIN_SERVERS.
Option F	F.    Increase PARELLEL__MIN_TIME_THRESHOLD.
Correct Answer	A,C,D,F

Explanation

Question ID 2512	In Your Database, The Cursor_Shareing Parameter is set to EXACT. In the Employees table, the data is significantly skewed in the DEPTNO column. The value 10 is found in 97% of rows. Examine the following command and out put.   Which three statements are correct?
Option A	A.    The DEPTNO column will become bind aware once histogram statistics are collected.
Option B	B.    The value for the bind variable will considered by the optimizer to determine the execution plan.
Option C	C.    The same execution plan will always be used irrespective of the bind variable value.
Option D	D.    The instance collects statistics and based on the pattern of executions creates a histogram on the column containing the bind value.
Option E	E.    Bind peeking will take place only for the first execution of the statement and subsequent execution will use the same plan.
Correct Answer	A,B,D

Explanation

Previous-Page 1 2 3 4 5 6 7 8 9. . . 60 61 Next-Page

Send email to admin@getfreedumps for new dumps request!!!