READ Free Dumps For Oracle- 1z0-050
| Question ID 1939 |
|
| Option A | A. Set the STATISTICS_LEVEL parameter to TYPICAL. |
| Option B | B. Change the STALE_PERCENT value for the CUSTOMERS_OBE table. |
| Option C | C. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE. |
| Option D | D. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERSJDBE columns. |
| Correct Answer | D |
| Question ID 1940 |
|
| Option A | A. Accept the recommended SQL profile. |
| Option B | B. Collect statistics for the related objects. |
| Option C | C. Run the Access Advisor for the SQL statement. |
| Option D | D. Run the Segment Advisor for recommendations. |
| Correct Answer | C |
