READ Free Dumps For Oracle- 1z0-117

Question ID 2582	You need to upgrade you Oracle Database 10g to 11g. You want to ensure that the same SQL   plans that are currently in use in the 10g database are used in the upgraded database initially, but new, better plans are allowed subsequently. Steps to accomplish the task: 1.    Set the OPTIMIZER_USE_SQL_BASELINE and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINE to TRUE. 2.    Bulk load the SQL Management Base as part of an upgrade using an STS containing the plans captured in Oracle Database 10g. 3.    Evolve the plan baseline using the DBMS_SPM.EVOLVE_PLAN_BASELINE procedure. 4.    Fix the plan baseline – using the DBMS_SPM.ALTER_SQL_PLANBASELINE procedure. 5.    Accept new, better plans using the DBMS_SPM.ALTER_SQL_PLAN_BASELINE procedure and manually load them to the existing baseline. 6.    Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE. Identify the required steps.
Option A	A.    1,    3,    4,    5
Option B	B.    1,    6,    3,    4, 5
Option C	C.    1,    2,    3,    5
Option D	D.    1,    2,    3,    4
Option E	E.    1,    6,    3
Option F	F.    1 and 2
Correct Answer	F

Explanation

Question ID 2583	You are administering a database supporting an OLTP workload where the users perform frequent queries for fetching a new rows as possible, involving join operations on recently inserted data. In addition at night, a few DSS queries are also performed. Examine the initialization parameters for the instance:     Which two options would you use for the optimizer?
Option A	A.    Set the OPTIMIZER_MODE initialization parameter to FIRST_ROWS_n.
Option B	B.    Add the hint ALL_ROWS in the DOS queries.
Option C	C.    Set the OPTIMIZER_INDEX_CACHING initialization parameter to 0.
Option D	D.    Add a hint INDEX_COMBINE in all DSS queries.
Option E	E.    Set the OPTIMIZER_INDEX_COST_ADJ initialization parameter to 100.
Correct Answer	A,E

Explanation

Previous-Page 1 2. . . 36 37 38 39 40 41 42. . . 60 61 Next-Page

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