READ Free Dumps For Oracle- 1z0-050

Question ID 1897	You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11 g: 1.    Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2.    Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities?
Option A	A.    to minimize plan regression due to the use of a new optimizer version
Option B	B.    to completely avoid the use of new plans generated by a new optimizer version
Option C	C.    to prevent plan capturing when the SQL statement is executed after the database upgrade
Option D	D.    to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
Correct Answer	A

Explanation

Question ID 1898
Option A	A.    The index is not used by the optimizer but is maintained during DML operations.
Option B	B.    The index is not used by the optimizer and is not maintained during DML operations.
Option C	C.    The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.
Option D	D.    The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.
Correct Answer	A

Explanation

Previous-Page 1 2. . . 57 58 59 60 61 62 63. . . 177 178 Next-Page

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